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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 list all the database in server tsql

Author  Topic 

oracle_corrgi
Yak Posting Veteran

98 Posts

Posted - 2006-08-23 : 04:11:42
hi

how to list all the database in server from tsql or command prompt eg:node1 i have more then 45 database
i have 3 server


thanxs
prabhu-bangalore


database

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-08-23 : 04:14:45
Select [Name] From Master..Sysdatabases

Chirag
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-08-23 : 07:09:09
You should be able to find out routine information lije this in the SQL Server Book Online.


SQL Server 2000 Books Online
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp

SQL Server 2005 Books Online
http://msdn2.microsoft.com/en-us/library/ms130214.aspx




CODO ERGO SUM
Go to Top of Page
   

- Advertisement -