Can I turn browser service off with multiple nics / Ips?

All,
We’d like to turn the unused services off on our production machine. Can we
turn the sql browser service off under the following conditions:
-No named instances
-There are 2 nics that sql server needs to listen on (different IP
addresses, both port 1433)
-The production database is mirrored.
Thanks in advance.
Hi
I think you should be ok to turn it off see http://tinyurl.com/yegdeu but
you can easily switch it back on if you do have problems!
John
"sqlboy2000" wrote:

> All,
> We’d like to turn the unused services off on our production machine. Can we
> turn the sql browser service off under the following conditions:
> -No named instances
> -There are 2 nics that sql server needs to listen on (different IP
> addresses, both port 1433)
> -The production database is mirrored.
> Thanks in advance.
>
|||Thanks, it works great.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I think you should be ok to turn it off see http://tinyurl.com/yegdeu but
> you can easily switch it back on if you do have problems!
> John
> "sqlboy2000" wrote:

Can I turn browser service off with multiple nics / Ips?

All,
We’d like to turn the unused services off on our production machine. Can w
e
turn the sql browser service off under the following conditions:
- No named instances
- There are 2 nics that sql server needs to listen on (different IP
addresses, both port 1433)
- The production database is mirrored.
Thanks in advance.Hi
I think you should be ok to turn it off see http://tinyurl.com/yegdeu but
you can easily switch it back on if you do have problems!
John
"sqlboy2000" wrote:

> All,
> We’d like to turn the unused services off on our production machine. Can
we
> turn the sql browser service off under the following conditions:
> - No named instances
> - There are 2 nics that sql server needs to listen on (different IP
> addresses, both port 1433)
> - The production database is mirrored.
> Thanks in advance.
>|||Thanks, it works great.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I think you should be ok to turn it off see http://tinyurl.com/yegdeu but
> you can easily switch it back on if you do have problems!
> John
> "sqlboy2000" wrote:
>

Can I take print the report using crystal report.

Hi,
I am displaying the report through web using jsp and IBM RAD
Everything is working fine . but I am able to take the print through browser.

Now I am unable to take print of a report using crystal report. .

Is it possible to print the report ? .

when I click on the print option on a tool bar of a crystal report 10.
it display the print dialog box.
but it will not print the report .
But the report will be displayed in another browser.
Please send me the solution as soon as possible it is very very urgent...
Regards
Naltu.Make sure Printer is properly connect to the system

can I return output from stored procedure into an HTA to display in browser?

Hi all. I have a stored procedure on my sql server that returns a
simple informtation about that tim a database was backed up. I owuld
like to create an HTA that operator types can look at to make sure
that the backups finished, can someone help me do this?

The stored procedure in called sp_lastback and the output looks like
this:

database days since backup timestamp of backup
dbase1 0 2004-10-14 00:41:21.000
dbase2 0 2004-10-14 00:08:36.000
dbase3 1 2004-10-13 22:46:57.000

Can this be done? If someone could help me with this simple problem, I
could probably reuse the same method a 100 useful ways.

Thanks in advance!"sumGirl" <emebohw@.netscape.net> wrote in message
news:a5e13cff.0410141529.23a19fd8@.posting.google.c om...
> Hi all. I have a stored procedure on my sql server that returns a
> simple informtation about that tim a database was backed up. I owuld
> like to create an HTA that operator types can look at to make sure
> that the backups finished, can someone help me do this?
> The stored procedure in called sp_lastback and the output looks like
> this:
> database days since backup timestamp of backup
> dbase1 0 2004-10-14 00:41:21.000
> dbase2 0 2004-10-14 00:08:36.000
> dbase3 1 2004-10-13 22:46:57.000
> Can this be done? If someone could help me with this simple problem, I
> could probably reuse the same method a 100 useful ways.
> Thanks in advance!

You'll probably get a better response in a group for HTA users. I guess you
could write a client script to execute the procedure with ADO, then loop
over the ResultSet and build the .hta file dynamically, but I have no idea
about any details.

Simon|||Here's a generic technique to render a resultset using dynamic html. There
may be better ways to accomplish the task, though.

<html>
<head>
<body>
<Script Language="VBScript"
Sub btnListBackups_OnClick()

Set oConnection = CreateObject("ADODB.Connection")

oConnection.Open "Provider=SQLOLEDB" & _
";Data Source=" & "DBDELTA1" & _
";Integrated Security=SSPI"

Set recordSet = oConnection.Execute("EXEC tempdb..sp_lastback")
myResultTable = "<table border=""1"">"
myResultTable = myResultTable & "<tr>"
For i = 0 To recordSet.Fields.Count - 1
myResultTable = myResultTable & _
"<th>" & _
recordSet.Fields(i).Name & _
"</th>"
Next
myResultTable = myResultTable & "</tr>"
Do While Not recordSet.EOF
myResultTable = myResultTable & "<tr>"
For i = 0 To recordSet.Fields.Count - 1
myResultTable = myResultTable & _
"<td>" & _
recordSet.Fields(i).Value & _
"</td>"
Next
myResultTable = myResultTable & "</tr>"
recordSet.MoveNext
Loop
myResultTable = myResultTable & "</table>"
recordSet.Close
oConnection.Close

Results.innerHTML = myResultTable
End Sub

</script
<input type="button" id="btnListBackups" value="List Backups">
<hr>
<nobr Id=Results></nobr>
</body>
</html
--
Hope this helps.

Dan Guzman
SQL Server MVP

"sumGirl" <emebohw@.netscape.net> wrote in message
news:a5e13cff.0410141529.23a19fd8@.posting.google.c om...
> Hi all. I have a stored procedure on my sql server that returns a
> simple informtation about that tim a database was backed up. I owuld
> like to create an HTA that operator types can look at to make sure
> that the backups finished, can someone help me do this?
> The stored procedure in called sp_lastback and the output looks like
> this:
> database days since backup timestamp of backup
> dbase1 0 2004-10-14 00:41:21.000
> dbase2 0 2004-10-14 00:08:36.000
> dbase3 1 2004-10-13 22:46:57.000
> Can this be done? If someone could help me with this simple problem, I
> could probably reuse the same method a 100 useful ways.
> Thanks in advance!|||Thanks Dan! Thats exactly the kind of example I can run with!