What do you miss out on with Compaiblity Level 80 in SQL Server 2005?

Question

What do you miss out on with Compaiblity Level 80 in SQL Server 2005?

JamesNZ

SSCommitted

Points: 1615
More actions
May 3, 2009 at 6:41 pm

#133834

If you set the Compaiblity Level to 80 for a database in SQL Server 2005, what do you miss out on?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 1

The engine interprets SQL code as if it were SQL 2000 code, so you can't run any 2005 functions. As far as performance improvements in how the tables, indexes, backups, etc. work, those perform at 2005 levels.

It just changes the way the query processor interprets and allows SQL code.

Ken Simmons SSCertifiable Points: 7822 More actions · Answer 2

This link should give you a good idea on the differences between the compatibility modes.

http://msdn.microsoft.com/en-us/library/ms178653(SQL.90).aspx

Ed Zann SSCrazy Eights Points: 8694 More actions · Answer 3

Another thing you will notice is that you cannot run Standard Reports from Management Studio on a level 8.0 database.

BLADE-1043594 SSCrazy Points: 2576 More actions · Answer 4

You cant run any sql2005 functions

[font="Comic Sans MS"]+++BLADE+++[/font]:cool:

JamesNZ SSCommitted Points: 1615 More actions · Answer 5

JamesNZ

SSCommitted

Points: 1615

May 4, 2009 at 3:48 pm

#988446

Thanks guys 🙂

MMartin1 One Orange Chip Points: 27795 More actions · Answer 6

one of the interesting things about 90 is that it can treat bit fields as true, false, or NULL (rather than just true or false)

----------------------------------------------------