Friday, March 9, 2012

Exceptions and damaged databases in SQL Express 2005 & C#

Hi,

When a database has become corrupted (for whatever reason), when you try to open a connection to it using the SqlConnection class in C#, will it allow the connection to open? I'm trying to figure out if it will allow the connection to be opened, but will throw an SqlException when a command is sent to the server.

Thanks,

KingyNL

When you try to open a connection, exception will thrown if damaged database is default for current login or specified as "initial catalog" parameter in connection string.

Good luck,

Evergray

--

Words mean nothing...

No comments:

Post a Comment