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 |
|
msrs
32 Posts |
 Posted - 2007-09-28 : 02:04:55
|
Hi all, How to find out how many databases are there in a single server.example: server name 172.16.9.33 i want to find out how many databases are there in this server.Any solution for this plz help me. Thanks&Regards,Msrs |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-28 : 02:45:31
|
| Would this do?SELECT COUNT(*)FROM master.dbo.sysdatabasesKristen |
 |
|
|
renu
Starting Member
47 Posts |
Posted - 2007-09-28 : 02:53:26
|
| oh koolllllll |
|
|
|
msrs
32 Posts |
Posted - 2007-09-28 : 05:47:03
|
| yes it's working but already i tried this on my own. any way thank u Kristen.Thanks&Regards,Msrs |
|
|
|
|
|
|
How many databases are there in a single server