Announcement

Collapse
No announcement yet.

How to change compatibility of SQL server 2000 to SQL Server 2005?

Collapse

Ads on showthread pages

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to change compatibility of SQL server 2000 to SQL Server 2005?

    WordPress Hosting on SSD Servers
    Upgrading databases from SQL Server 2000 to SQL Server 2005 using backup and restore method or detach and attach method the compatibility level does not automatically change. Hence, to change the database compatibility, follow below mentioned steps:

    1. Login in SQL Server Management Studio.
    2. Expand database from the left hand side.
    3. Right click on the database.
    4. Click on Properties.



    5. Click on Option tab.
    6. Select SQL Server 2000 (80) from the Compatibility level section as shown in below figure.



    7. Click on Ok button.

  • #2
    ASP.Net Hosting starts @ $3.18/Mo.
    Re: How to change compatibility of SQL server 2000 to SQL Server 2005?

    The database gets converted as soon as you restore it on a SQL Server 2005 instance.
    The only effects of the compatibility level are:
    * Most new reserved words will not generate an error if used as column or table name (at the cost of not being able to use the new function).
    * Some (not all!) behaviour changes of existing functionality are only active in the newer compatibility level (in case you relied on the old
    behaviour).
    * Some features that have been deprecated for a while already are only available in lower compatibility settings.

    Also, changing the compatibility setting won't enumerate any issues. That's what the upgrade advisor is used for.
    Last edited by kilter; 11-24-2009, 03:09 AM.

    Comment

    Working...
    X
    Sign up for a News Letter Click here to sign up