How to Retrive DB informations in sql server

SELECT db.name AS database_name,
sps.name AS owner,
db.create_date,
db.compatibility_level,
db.recovery_model_desc
FROM sys.databases db INNER JOIN sys.server_principals sps
ON db.owner_sid = sps.sid
Ebook Download
View all
SQL Jobs
Read by 0 people
Download Now!
Learn
View all