Upgrading SQL 2000 code to SQL 2005

  • Hello!
     
       I am currently evaluating our SQL 2000 code to identify how much of it has to be rewritten/modified in order to make it work with SQL 2005. I looked at Upgrade Advisor but unfortunately it didn't provide me with a lot of details regarding to database code I am planning to upgrade.

      We are planning to keep 8.0 database compatibility mode once we move to SQL Server 2005.

       Can someone share experience regarding TSQL code/constructions that won't work under SQL Server 2005?

     
    Any help is greatly appreciated,
    Igor
  • You don't need to post your question across multiple boards, everyone people usually check all boards.

    Follow Thread here

    http://www.sqlservercentral.com/forums/post.aspx?forumid=146&messageid=254504

     

  • Ray,

    Sorry, I wasn't sure which group it really belongs to.

    Thanks,

    Igor

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply