How To get Database Name & status From SQl Server

There is a syntax of getting database name & status from sql server.

SELECT DB_NAME() AS DatabaseName, DATABASEPROPERTYEX('master', 'Status') AS DBStatus

---

Possibly related posts: (automatically generated)

• How to get the all table name in a particular DataBase in SQL Server 2005
• Deploy personal web starter kit to remote host
• NCsoft’s strict server balance policy for Aion
• ’Name Us’ Finds The Missing