1 Replies - 1815 Views - Last Post: 29 March 2010 - 11:27 AM

#1 dineeshd   User is offline

  • member icon

Reputation: 39
  • View blog
  • Posts: 619
  • Joined: 30-June 08

MSSQL Snippet to Check the Current Database Status.

Posted 28 July 2008 - 03:27 AM

Description: This is an easy method to find out the current status of the database.
SELECT DB_NAME() AS DBNAME, DATABASEPROPERTYEX('MASTER', 'STATUS') AS DBSTATUS

Is This A Good Question/Topic? 0
  • +

Replies To: MSSQL Snippet to Check the Current Database Status.

#2 Bow   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 0
  • Joined: 25-March 10

Re: MSSQL Snippet to Check the Current Database Status.

Posted 29 March 2010 - 11:27 AM

'''''''thanks!''''''''''''
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1