change compatabilty of one database? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

change compatabilty of one database?

Author

Topic

mayerl
Yak Posting Veteran

95 Posts

Posted - 2010-08-04 : 14:27:26

Afternoon,

I inherited a SQL server the dude slapped 2008 on there but all the databases have a compatibility level of 2000 (80). I'd like to test to see if changing the compatibility of a training database breaks the application. Can I do that safely without breaking any other databases?

Thanks

Laura

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-04 : 14:40:24

Yes

--
Gail Shaw
SQL Server MVP

mayerl
Yak Posting Veteran

95 Posts

Posted - 2010-08-04 : 14:43:19

Thanks Gail.

Kristen
Test

22859 Posts

Posted - 2010-08-04 : 15:48:14

Possibly helpful: "SQL2008 Migration: Hints and Tips SQL 2008" : http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources