Home Forums SQL Server 2005 SQL Server Newbies Help me buddy's... in sql server 2005 (topic:columns update) RE: Help me buddy's... in sql server 2005 (topic:columns update)

  • July 11, 2013 at 6:13 am

    #1631539

    DivyaMohankumar (7/11/2013)

    5) Now my question is how can i get the old values in the table , as i inserted.

    Get a backup that was taken before the update was done, restore it as a new database, copy the overwritten data out.

    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