Thursday, March 22, 2007

List all available databases on SQL Server

List all available databases on SQL Server: "List all available databases on SQL Server
This code snippet will show you how to list all available databases on a SQL Server box. The trick here is to query master..sysdatabases"

select * from master..sysdatabases

No comments: