Solved

Update SQL Server 2008 Database Compatibility level

Posted on 2011-03-23
2
688 Views
Last Modified: 2012-05-11
Hello

I have several databases in a SQL Server 2008 environment that are still set at 90, and should be 100 (they are all Microsoft apps so no worries about application support).

Can I just change this in SQL Server Management Studio?  Or should I do this by TSQL - first place the DB in single user, then update compatibility, then set it back to Multi-user?

thanks

0
Comment
Question by:markymark10
2 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 350 total points
ID: 35200441
No need to change to single user.  YOu can set it through TSQL or in the UI.  No harm to be done either way (unless you're using features that have been removed).
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 35200460
for tsql:
ALTER DATABASE database_name SET COMPATIBILITY_LEVEL =90  

Open in new window


for older database systems:
EXEC sp_dbcmptlevel database_name, compatibility_level value;

Open in new window


0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server merge records in one table 2 24
Sql Query with datetime 3 26
Please help with the below query - SQL Server 11 20
Find results from sql within a time span 11 33
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question