Have you tried using dbcmptlevel like that before? I was told by some not to do it, as there would be some issues doing this, since the 2000 DB would still have the 2000 system SP's.

>Hi, Dmitry,
>
>As you already discovered, the answer is yes.
>
>Now, if you want to use some of the SQL '05 specific commands, I believe you'll need to set the sp_compatibility level.
>
>

>sp_dbcmptlevel Northwind, 90
>

>
>Hope that helps...