How to return Database Status in C#

Question

0.00/5 (No votes)

See more:

How to return MS SQL server Database Status as shown in the Image attached, in C# like it should return me "Offline" , "pending" or other.

[Click For Image]

Posted 8-Aug-14 0:12am

ali_khan_1

Updated 8-Aug-14 1:04am

v2

Add a Solution

Comments

Herman<T>.Instance 8-Aug-14 6:13am

I do not open images from links.....

SRK90 8-Aug-14 6:19am

you mean, if the database value says offline or pending or etc.....an image should get displayed on your web page based on the different status instead of printing offline, pending or etc???? .....Please correct me if i am wrong.

ali_khan_1 8-Aug-14 7:06am

no not the values...in front of DB name in braces there is a status how to return that with DB name

2 solutions

Solution 2

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

Posted 8-Aug-14 1:19am

Sibeesh Venu

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Chris Quinn · Accepted Answer · 2014-08-08T00:23:00

Solution 1

select name,state_desc from sys.databases

Posted 8-Aug-14 0:23am

Chris Quinn

Comments

[no name] 8-Aug-14 7:20am

+5You can see my solution also (Solution 2)