Category: Database


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...


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...