Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
2000 to 2005 Compatability Setting
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01153917
Message ID:
01153930
Views:
14
>Recently I migrated a 2g 2000 database to 2005 using detach/attach and then fixing all the logins.
>
>When I finished up I looked at the compatibility level for the new database and it was set at 8.0
>
>All has been running fine and I am now considering setting compatibility to 9.0 for the advanced 2005 features. My question: If all has been working well is there any danger in doing this? What is actually changed by adjusting compatibility to 9.0?

There're a lot of changes. See sp_dbcmptlevel (Transact-SQL) SQL 2005 BOL for details.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform