How do you check collation and compatibility level for a database?
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 […]