Saturday, April 26, 2014

SQL Query to check number of systems in Database

SQL Query to check the number of databases in the sQL server 2008:

select * from sys.sysdatabases

It will yields following results

| master    1   |
| ------------ |
| tempdb    2  |
| ------------ |
| model    3    |
| ------------ |
| msdb    4    |
| -----------  |