Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 715
  • Last Modified:

Update SQL Server 2008 Database Compatibility level

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
markymark10
Asked:
markymark10
1 Solution
 
chapmandewCommented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now