9 Nisan 2019 Salı

Sql Server Database Language Change



-- Set to single-user mode
ALTER DATABASE yourdatabasename
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
  
-- change collation
ALTER DATABASE yourdatabasename  
COLLATE Turkish_CI_AS;  
GO  

-- Set to multi-user mode
ALTER DATABASE yourdatabasename
SET MULTI_USER WITH ROLLBACK IMMEDIATE;
GO  

--Verify the collation setting.  
SELECT name, collation_name  
FROM sys.databases  
WHERE name = yourdatabasename';