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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 instance and database name

Author  Topic 

shinobigoh
Starting Member

13 Posts

Posted - 2010-04-14 : 00:02:21
my sql server 2000 database crashed
do u know any way to get the instance and database name without querying

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-14 : 00:08:58
You can get the instance name via Server Network Utility or by looking at the MSSQL* services in the Services applet in Admin Tools/Contral Panel. For the databases, you'd have to wait until you are connected unless you can tell the names via the files.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -