You have a database that was created in an earlier version of SQL and restored onto a later version. It may be necessary to change the SQL version of your database.
| Note |
|---|
There are potential performance improvements by making sure the compatibility level of your database matches that of the SQL Server version. When you restore a database from an older version of SQL Server to a newer version, by default the restored database has the compatibility version set to the older SQL Server version. It is recommended to change this. |
Step-by-step guide
| Warning | ||
|---|---|---|
| ||
This tasks needs advanced SQL programming skills. |
...