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


No comments:

Post a Comment

Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists

If you received below error while attaching a .mdf file in cluster environment please follow below steps to resolve the issue ERROR Ca...