some infrastructure

hi all,
we are designing a application to work along with sql server 2000.

we are looking for the ability to recognize, by t-sal code, all sql servers
running in the network.
I heard that there is a local component on each machine called "listener".
I'd love to get a few tips/ links of how to.. work with it.(or any other ide
a)

another thing, we are also looking for a way to monitor the logs (the ones
under the managment folder in enterprise manager) via t-sal.
for now, our best idea is to import the log files into a table (using bcp
and format files) and the to read from the table, but I can imagine there ar
e
better ways.

and, is there a way to monitor (again with sql code) current system values
(for example: cpu usage levels , disk performance.....)

thanks,
prem

Prem,

I'm not sure of a way to do this with T-SQL.  You might take a look at the
 ListAvailableSQLServ
ers method in SQL-DMO.  I'm not sure if this method
lists SQL Servers that have been hidden via the TCP/IP dialog Hide Server
option.  Also, you might check out the -L argument of the OSQL utility.

Again...it's not T-SQL but you might find the findstr utility useful for
scanning the errorlogs for errors.  See:

INF: How to Scan SQL Errorlog or DBCC Output for Errors
http://support.microsoft.com/kb/q115519/

HTH

Jerry
"prem" <prem@discussions.microsoft.com> wrote in message
news:286C16CF-D44E-4F6F-9FBF- E3A77213D373@microso
ft.com...
> hi all,
> we are designing a application to work along with sql server 2000.
>
> we are looking for the ability to recognize, by t-sal code, all sql
> servers
> running in the network.
> I heard that there is a local component on each machine called "listener".
> I'd love to get a few tips/ links of how to.. work with it.(or any other
> idea)
>
> another thing, we are also looking for a way to monitor the logs (the ones
> under the managment folder in enterprise manager) via t-sal.
> for now, our best idea is to import the log files into a table (using bcp
> and format files) and the to read from the table, but I can imagine there
> are
> better ways.
>
> and, is there a way to monitor (again with sql code) current system values
> (for example: cpu usage levels , disk performance.....)
>
> thanks,
> prem
>
>

Actually...now that I think about it you could probably call OSQL -L with
xp_cmdshell and INSERT..EXEC to do this in t-sql.

HTH

Jerry
"Jerry Spivey" <jspivey@vestas-awt.com> wrote in message
news:en1x%23AIxFHA.720@TK2MSFTNGP10.phx.gbl...
> Prem,
>
> I'm not sure of a way to do this with T-SQL.  You might take a look at the
>  ListAvailableSQLServ
ers method in SQL-DMO.  I'm not sure if this method
> lists SQL Servers that have been hidden via the TCP/IP dialog Hide Server
> option.  Also, you might check out the -L argument of the OSQL utility.
>
> Again...it's not T-SQL but you might find the findstr utility useful for
> scanning the errorlogs for errors.  See:
>
> INF: How to Scan SQL Errorlog or DBCC Output for Errors
> http://support.microsoft.com/kb/q115519/
>
> HTH
>
> Jerry
> "prem" <prem@discussions.microsoft.com> wrote in message
> news:286C16CF-D44E-4F6F-9FBF- E3A77213D373@microso
ft.com... 
>
>