Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pras
Starting Member
10 Posts |
 Posted - 2008-05-22 : 19:17:08
|
| Hi,How can i fetch the list of SQL Servers available along with their status like whether it is active or inactive? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-22 : 23:04:49
|
| Can run 'osql -L' in dos prompt to get list of running sql servers on your network. For inactive ones, we use bindview to look at servers' file system. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-05-23 : 03:43:49
|
| what's bindview?_______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-23 : 03:46:09
|
http://en.wikipedia.org/wiki/BindView
E 12°55'05.25"N 56°04'39.16" |
|
|
|
Pras
Starting Member
10 Posts |
Posted - 2008-05-27 : 19:44:16
|
quote:
Originally posted by Pras
Hi,How can i fetch the list of SQL Servers available along with their status like whether it is active or inactive?
Is there a way to get the details using a query what 'Osql -L' is listing from command prompt. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-27 : 19:55:04
|
| Just run osql -L from xp_cmdshell if you want to do it inside SQL Server. You can put the results into a table too using INSERT INTO/EXEC.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
|
|
|
List of Servers