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
|