We have a Sql Server 2005 DB. For whatever reason, the compatibility 
level (e.g. via sp_dbcmptlevel) is set to 80 (which is Sql Server 2000).

What are the consequences of that? Is there a performance penalty for my 
apps because of the compatibility level?

Regards

Frank
No, it does not relate to performance, it does to the new features such as 
ROW_NUMBER() function that won't work



"Frank Rizzo" <none@none.net> wrote in message 
news:O7CsZS8nKHA.4648@TK2MSFTNGP06.phx.gbl...
> We have a Sql Server 2005 DB. For whatever reason, the compatibility level 
> (e.g. via sp_dbcmptlevel) is set to 80 (which is Sql Server 2000).
>
> What are the consequences of that? Is there a performance penalty for my 
> apps because of the compatibility level?
>
> Regards 

Hi Frank,

Nops, there wont be any performance issue. But using the new features
of SQL Server 2005 in your code and architecture will increase the
performance of the database

--
Sriram
www.SQLLike.com