SQL Server Performance

running SQL 2005 script on Sql 2000

Discussion in 'SQL Server 2005 General Developer Questions' started by Akthar, Sep 21, 2006.

  1. Akthar New Member

    Hi guys,

    i got some syntax error when running a sql 2005 generated script on Sql 2000 is there a way to have the script backward compatible


  2. satya Moderator

    Look at BOL 2k5 for sp_dbcmptlevel stored procedure where you set the backwards compatibility level.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. bradmcgehee New Member

    You can also run the Upgrade Advisor tool included with 2005 to indentify the incompatable code so that it can be corrected to run properly under 2005 natively. See BOL for more info on the Upgrade Advisor.

    Brad M. McGehee, SQL Server MVP

Share This Page