• 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';  


  • You might also like

Bu Blogda Ara

Blogger tarafından desteklenmektedir.