Change collation - 

USE master; GO   -- Kill all spids to a single DB DECLARE @SQL VARCHAR(8000) SELECT @SQL=COALESCE(@SQL,'')+'Kill '+CAST(spid AS VARCHAR(10))+ '; ' FROM sys.sysprocesses WHERE DBID = DB_ID('DatabaseName') PRINT @SQL --EXEC(@SQL) Replace the print statement with exec to execute -- Set to single-user mode ALTER DATABASE [DatabaseName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO    -- Kill all spids to a single DB DECLARE @SQL VARCHAR(8000) SELECT @SQL=COALESCE(@SQL,'')+'Kill '+CAST(spid AS VARCHAR(10))+ '; ' FROM sys.sysprocesses WHERE DBID = DB_ID('DatabaseName') -- change collation ALTER DATABASE [DatabaseName]   COLLATE SQL_Latin1_General_CP1_CI_AS;   GO     -- Set to multi-user mode ALTER DATABASE [DatabaseName] SET MULTI_USER WITH ROLLBACK IMMEDIATE; GO     --Verify the collation setting.   SELECT name, collation_name   FROM sys.databases   WHERE name = N'DatabaseName';   GO