Wednesday, March 21, 2012

Retrieving SQl instances in network

hi,
I want to retrieve all instances in the network .

I am trying to use smoaplication.EnumAvailableSqlServers(true)

but the problem is i am using on sql cluster ..i am getting not only cluster instance but also instances present on the two nodes(these instances should be part of cluster and cannot be accessed)..so can u please tell me how do i just retieve only actual instances

i am using sql SMO|||

Hi,

you could hide the instances from the network using the network utility, but I am not sure if the cluster things are supporting this (but probably they will)

HTH, Jens K. Suessmeyer.


http://www.sqlserver2005.de

No comments:

Post a Comment