.NET Daily

Recommended Resources

Popular Content

Tagsql server


How To Solve: SQL Server detected a logical consistency-based I/O error: invalid protection option.

Posted on March 19th, 2018.

If you happen to receive the logical consistency-based I/O error, then your database probably ended up in an unusable state. SQL Server provide some options to repair it but it does that with the risk of potentially losing data. The syntax that I used to repair it is the following: ALTER DATABASE MyBrokenDB SET SINGLE_USER WITH ROLLBACK...



How to easily get a database connection string with Visual Studio

Posted on January 5th, 2014.

Because I’m working on several projects at a time, it’s very hard for me to remember any connectivity data for any of the projects. Same thing for connection strings. However, with the help of Visual Studio I can generate a connection string pretty fast if I know the server address and the credentials. Here are the steps I...