Home Forums SQL Server 2008 SQL Server 2008 - General Rollback Script RE: Rollback Script

  • September 5, 2012 at 7:11 am

    #1533785

    Junglee_George (9/5/2012)

    Yes Gail, rollback script is what I need.

    Can you pls help on this? Just a sample SQl Script will do.

    Thanks

    Sure.

    ALTER PROCEDURE <the name of the procedure here> (< the parameters of the procedure here>)

    AS

    <the text of the procedure as it was before you made the changes>

    GO

    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