Daily Archives: 10/24/2014

How do you check collation and compatibility level for a database?

This entry was posted in Sql Server DBA Sql Server tutorials and tagged collation compatibility database server sql on by .

Scenario There is a common practice in the DBA world to work on a daily basis with back-ups and restoring of databases on different servers with different configurations. In an ideal world you would have the same collation and the same compatibility level on all your machines but for cases when this doesn’t happen here’s […]