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 potentially significant performance improvements to be made 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 the compatibility level of the database to match that of the SQL Server version. |
Step-by-step guide
| Warning |
|---|
| title | SQL Advanced programming skills required |
|---|
|
This tasks needs advanced SQL programming skills. |
...
Review this link and follow the steps detailed - https://msdn.microsoft.com/en-AU/library/bb933794.aspx
Related articles
| Filter by label (Content by label) |
|---|
| showLabels | false |
|---|
| max | 5 |
|---|
| spaces | J7UG |
|---|
| showSpace | false |
|---|
| sort | modified |
|---|
| reverse | true |
|---|
| type | page |
|---|
| cql | label = "sql" and type = "page" and space = "J7UG" |
|---|
| labels | SQL |
|---|
|
| Page Properties |
|---|
|
| Related issues | | Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 2c1cfd4f91fbcd9b-51875d0b-3e043b97-87d0a585-644aa099c48f1a06ec62a231 |
|---|
| key | JIWA-533 |
|---|
|
|
|---|
|