Post reply

SQL Sever 2008 changes

  • February 9, 2012 at 2:13 am

    #252694

    Hi,

    We are upgrading our database from sql server 2000 to 2008. I want to make sure that our application will run smoothly after upgrade.

    What are the syntaxes of sql 2000 which are not supported in sql 2008? or other features which we might need to change to make them work in 2008?

  • February 9, 2012 at 2:19 am

    #1444937

    That's all in Books Online (though you'll need to look in 2 places - changes in SQL 2005 and changes in sql 2008).

    Have you run the upgrade advisor? Have you fixed any errors it found?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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