Sql Severs on the network
-
Hi, I have to find all available servers in the network. i have used SQLDMO.But it's a componenet. so can anyone tell me the solution other than that. Thanks in advance sri
-
Hi, I have to find all available servers in the network. i have used SQLDMO.But it's a componenet. so can anyone tell me the solution other than that. Thanks in advance sri
What do you mean 'it's a component' ???
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
What do you mean 'it's a component' ???
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
If i use SQLDMO I have to add reference.Is there anyother way to get all available servers and databases?
-
If i use SQLDMO I have to add reference.Is there anyother way to get all available servers and databases?
Without adding a reference to a component that does it ? I doubt it, not easily. What's wrong with adding a reference to a component ?
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
If i use SQLDMO I have to add reference.Is there anyother way to get all available servers and databases?
My product's requirement is like this. i shouldnt refer any com componenents.
-
My product's requirement is like this. i shouldnt refer any com componenents.
OK, then I guess you are screwed, if someone feels that your spec has to include denying you the tools for the job.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
Hi, I have to find all available servers in the network. i have used SQLDMO.But it's a componenet. so can anyone tell me the solution other than that. Thanks in advance sri
-
My product's requirement is like this. i shouldnt refer any com componenents.
-
My product's requirement is like this. i shouldnt refer any com componenents.
-
Hi, I have to find all available servers in the network. i have used SQLDMO.But it's a componenet. so can anyone tell me the solution other than that. Thanks in advance sri
Hi You can use one of the following options: 1. use the GetDataSources method that belong to the SqlDataSourceEnumerator class like the following: DataTable datatable1 = SqlDataSourceEnumerator.Instance.GetDataSources(); 2.use the EnumRegisteredServers method tht belong to the SmoApplication.SqlServerRegistrations class for furture instruction serch for smo objects in google