To change the default collation of my SQL 2019 instance on my laptop to “SQL_Latin1_General_CP1_CI_AS” I …
– Found the saved the location of sqlservr.exe into notepad.
– Added [cd ] in front of the path (that’s cd and a space, without the square brackets)
– Added a second line in notepad [sqlservr -m -T4022 -T3659 -s”SQL2019″
-q”SQL_Latin1_General_CP1_CI_AS”] (without the square brackets)
– Stopped the SQL Server service
– Opened a Command Prompt as Administrator
– Executed the first command (cd …)
– Executed the second line (sqlservr …)
– Rebooted.
Database Consultant 