Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Will Northwind database for 2000 work with SQL 2005
Message
From
06/05/2007 23:45:43
 
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01222901
Message ID:
01222978
Views:
16
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...

(On an infant's shirt): Already smarter than Bush
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform