Search This Blog

Monday, March 7, 2011

SQL DBA - To Get all the DataBase Names in a Server

SELECT Database_id,name,create_date,is_read_only,state_desc,recovery_model_desc FROM sys.databases

No comments: