Snapshot Isolation and Compatibility Level 80

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)

Snapshot Isolation and Compatibility Level 80

Author

Topic

ijnoj09
Starting Member

2 Posts

Posted - 2009-03-09 : 19:01:02

Hi,

Does anyone know if snapshot isolation will run on databases running under compatibility level 80 in SQL2008?

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-09 : 20:15:51

I don't think it will because when you set the compatibility mode to 80; it is executing code as if it was SQL 2000.

Example: http://blogs.msdn.com/gertd/archive/2008/02/16/database-compatibility-level.aspx

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

heavymind
Posting Yak Master

115 Posts

Posted - 2009-03-10 : 05:54:03

the answer is
DEFINITELY NO!

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-10 : 06:45:45

quote:
Originally posted by ijnoj09

Hi,

Does anyone know if snapshot isolation will run on databases running under compatibility level 80 in SQL2008?

why using compatibility level 80 if you're on sql 2008? is it because you've some old types of join queries still being used?

ijnoj09
Starting Member

2 Posts

Posted - 2009-03-10 : 17:27:15

quote:
Originally posted by visakh16

why using compatibility level 80 if you're on sql 2008? is it because you've some old types of join queries still being used?

Yes, we have a old vendor application that we are running and until we can upgrade the application, we need to run it at compatibility level 80.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources