Step 1 - Determine the SQL Server Collation
Step 2 - Stop the SQL Server Services
Step 3 - Open a Command Prompt and Navigate to the Binn Directory and type following command on command prompt:
sqlservr -m -T4022 -T3659 -s"SQLEXP2014" -q"SQL_Latin1_General_CP1_CI_AI"
Parameters used:
[-m] single user admin mode
[-T] trace flag turned on at startup
[-s] sql server instance name
[-q] new collation to be applied
Step 4 - Start SQL Server and Verify Collation
No comments:
Post a Comment