Tagged: MSSQL

0

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

0

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

0

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