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 |
|
kennyja
Starting Member
1 Post |
 Posted - 2011-08-31 : 09:43:52
|
| Is there an easy way to tell if a servers is actually hsoting a db table? Installation of Studio Manager will put SQL server in the installed programs list on a Windows server even if that server is not actually hosting any databases.Is there an easy way to remotely tell if that server is actually hosting any tables?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-08-31 : 09:50:08
|
| You can use the following in a command prompt:tasklist /S servername | findstr /I "sqlserv"That will list any running SQL Server Database Engine services. If you want to know if they're hosting any non-system databases:sqlcmd -S servername -E -Q"select name from sys.databases where name not in('master','model','tempdb','msdb')"If you get any results then there are databases on that server. They may be offline, or mirrored, or otherwise inaccessible, you'd have to investigate further. |
 |
|
|
|
|
|
Is there actually a table on this host?