By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

database exist or not

P: 28
how to check if database exist or not in sqlserver through code.
if not exists i will give msgbox to user
otherwise i will allow the user to create reports

pls any one give me solution.its urgent
Jan 30 '09 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 2,367
Do you need to check if the database exist or not
Do you want to check if the database is UP and RUNNING or SHUT DOWN?
Jan 30 '09 #2

P: 28
no.only i want to check database exists or not through code

so i need a query for this
Jan 30 '09 #3

Expert 2.5K+
P: 2,878
Try using this function.

-- CK
Jan 30 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.