Friday, July 11, 2014

List databases from SQL Server 2000

with below query you can List the databases from SQL Server 2000


SELECT CATALOG_NAME 
    FROM INFORMATION_SCHEMA.SCHEMATA 
    ORDER BY CATALOG_NAME