List of SQL Servers Available in a network

[João Santa Bárbara]

Hi all
i need to do a search to all my network to find the SQL servers active, but
i don´t want to use SQLDMO. is there another way to do it ???

THKS

JSB

[mdb]

"João Santa Bárbara" <jo****@i24portugal.com> wrote in
news:Oe**************@TK2MSFTNGP15.phx.gbl:

i need to do a search to all my network to find the SQL servers
active, but i donït want to use SQLDMO. is there another way to do it

http://www.codeproject.com/cs/databa...Enumerator.asp

[Willy Denoyette [MVP]]

"mdb" <m_b_r_a_y@c_t_i_u_s_a__d0t__com> wrote in message
news:Xn****************************@207.46.248.16. ..

"João Santa Bárbara" <jo****@i24portugal.com> wrote in
news:Oe**************@TK2MSFTNGP15.phx.gbl:

i need to do a search to all my network to find the SQL servers
active, but i donït want to use SQLDMO. is there another way to do it

http://www.codeproject.com/cs/databa...Enumerator.asp

Waw .... removing SQLDMO dependency in favor of ODBC dependency!.

Willy.

[mdb]

"Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in news:e#8j
$w*********@TK2MSFTNGP12.phx.gbl:

http://www.codeproject.com/cs/databa...Enumerator.asp

Waw .... removing SQLDMO dependency in favor of ODBC dependency!.

:) Haha

What do you want?? Its also dependent on having a network connected! :)
--
-mdb

[mdb]

"Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in news:e#8j
$w*********@TK2MSFTNGP12.phx.gbl:

http://www.codeproject.com/cs/databa...Enumerator.asp

Waw .... removing SQLDMO dependency in favor of ODBC dependency!.

:) Haha

What do you want?? Its also dependent on having a network connected! :)
--
-mdb

[Willy Denoyette [MVP]]

"mdb" <m_b_r_a_y@c_t_i_u_s_a__d0t__com> wrote in message
news:Xn****************************@207.46.248.16. ..

"Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in news:e#8j
$w*********@TK2MSFTNGP12.phx.gbl:

http://www.codeproject.com/cs/databa...Enumerator.asp

Waw .... removing SQLDMO dependency in favor of ODBC dependency!.

:) Haha

What do you want?? Its also dependent on having a network connected! :)
--
-mdb

The problem with this is that OP doesn't mention why he doesn't want to use
SQLDMO, now using ODBC he needs to PInvoke 4 API's, while a simple PInvoke
of a single Win32 API "NetServerEnum" could be used to get all SQL servers
in the network without any dependency at all.
Willy.

[mdb]

"Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in
news:uV**************@TK2MSFTNGP10.phx.gbl:

The problem with this is that OP doesn't mention why he doesn't want
to use SQLDMO, now using ODBC he needs to PInvoke 4 API's, while a
simple PInvoke of a single Win32 API "NetServerEnum" could be used to
get all SQL servers in the network without any dependency at all.

Good information... I provided an answer - and the only one I knew at the
time - never said it was the best answer! :)

--
-mdb