Change collation of MSSQL From Changing SQL Server Collation After Installation >> sc queryex type= service state= all | find /i "SQL Server" DISPLAY_NAME: SQL Server (MSSQLSERVER) DISPLAY_NAME: SQL Server Browser DISPLAY_NAME: SQL Server Agent (MSSQLSERVER) DISPLAY_NAME: SQL Server VSS Writer >> net stop "SQL Server (MSSQLSERVER)" The SQL Server (MSSQLSERVER) service is stopping.... The SQL Server (MSSQLSERVER) service was stopped successfully. cd c:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\ -- SET CASE SENSITIVE -- sqlservr -m -T4022 -T3659 -s"MSSQLSERVER" -q"SQL_Latin1_General_CP1_CS_AS" [-m] single user admin mode [-T] trace flag turned on at startup [-s] sql server instance name [-q] new collation to be applied -- SET CASE IN-SENSITIVE -- sqlservr -m -T4022 -T3659 -s"MSSQLSERVER" -q"SQL_Latin1_General_CP1_CI_AS"
הבלוג של זיו בירר