Tagged: MSSQL


How to delete a locked DB in MSSQL?

One of the problems I had is that I couldn’t delete a locked DB in the SQL Management Studio.  Here is the code that is deleting the DB. Just change the MYDB with your...


ASP.NET identification with MS SQL Server

Here is an example connection string to the MS SQL Server. :Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; Connection string using windows authentication: Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security = true;In <system.web> I have added <authentification mode=”Windows”/> <authorization><deny users=”?”/></authorization>...


MSSQL 2010 Inserting Cyrrilics

I did face an interesting problem today. I have MS SQL server 2010 and I wanted to insert Cyrillics alphabet in it. The type of the field is nvarchar but when i insert data...