Preface In an earlier post we spoke about discovering that we can change our SQL Server Instance by restarting SQL Server with the /q option. That post is here. Real life experience If truth be told, our first use-case was a recently installed SQL Server instance without any user databases. In this post we … Continue reading SQL Server – Changing Sql Instance Collation – via sqlservr/-q – Little Traps
SQL Server – Changing Sql Instance Collation – via sqlservr/-q – Little Traps
Daniel Adeniji
3416, 5804, Collation, Microsoft, Msg 468, SQL Server, Technical
A user transaction that accesses memory optimized tables or natively compiled procedures cannot access more than one user dat abase or databases model and msdb, and it cannot write to master, and retry the operation., Cannot change sort order or locale. An unexpected failure occurred while trying to reindex the server to a new collation, Cannot resolve the collation conflict, Error: 3416, Error: 3434, Error: 41317, Error: 5804, or collation cannot be changed at the server level because at least one database is not writable. Make the database writable, The server contains read-only files that must be made writable before the server can be recollated