gururajkamath (11/10/2009)
the query provided by you is not showing database count, it can be used for table count, how we can get the database count in the sql server? is there any way?
The query provided by Jorge will give you record count for all tables in a database.
To list out databases, you can query sysdatabases table
select * from sysdatabases
will run for both 2000 and 2005
OR
select * from sys.databases
specific to sql server 2005