How to check for the existence of a DB?

I am wondering if there is an elegant way to check for the existence of a DB? In brief, how do test the connection of a db connection string?

Thanks

How can I tell if a SQL Server database is being used?

Another way to see if your database is in use is to look and see if the indexes are being used. Information on index usage is held in the sys. dm_db_index_usage_stats table since the last server reboot, and can be queried using this statement which can be tailored to select the data you need.

Set the Initial Catalog=master in the connection string and execute:

select count(*) from sysdatabases where name = @name

with @name set to the name of the database.

If you want to check the connection string as a whole (and not existence of an independent database), try connecting to it in a try/catch block.

Related questions

Testing for null reference always returns false... even when null

Can someone explain this LinkDemand warning when subclassing a Windows control?

SQL Server Strings Padded with Whitespace on Insert - why?

Best practice for passing object

Exception in Destructor (c#)?

When would I use an alias on a using Directive?

How to read XML file in c#?

Remove trailing zeros from byte[]?

Handling Shift-Enter event in a textbox

Why use Windows.Forms.Timer at all?

Need some explaination with beginner C# code

What happens to an if statement not followed by curly braces? [closed]

Slow LINQ query for .ToArray()

Length of string WITHOUT spaces (C#)

How to differentiate between overloads when an argument is null

StringFormat for binding TimeSpan in XAML does not work

Application object is being shut down exception

Is there a delay in between statements in C#?

Accessing App.config in a location different from the binary

Which is correct way to check for Null exception?

How to check for the existence of a DB?

Tags:

c#

sql

database

sql-server

connection-string

Martin

People also ask

1 Answers

mmx

Recent Activity

Donate For Us