InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 21:43:43 GMT20http://www.sqlservercentral.com/Forums/Topic1354387-391-1.aspxThank You Gail n Mike..You guys really helped me..Thu, 06 Sep 2012 02:54:50 GMTJunglee_Georgehttp://www.sqlservercentral.com/Forums/Topic1354387-391-1.aspx[quote][b]Junglee_George (9/5/2012)[/b][hr]Yes Gail, rollback script is what I need.Can you pls help on this? Just a sample SQl Script will do.Thanks[/quote]Sure.[code="sql"]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[/code]Wed, 05 Sep 2012 07:11:34 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1354387-391-1.aspxThere is no generic "rollback script" for this sort of change that anyone can give you.You need to take the soure of the procedure, and change it to remove the change you made last week.It is a very good idea to have some form of version control system to hold all stored procs, triggers, etc etc. We use Subversion - but there are many others. I fyou do not have that in place you can always script ethe procedure as it is now from the database.MikeWed, 05 Sep 2012 05:06:27 GMTMike Johnhttp://www.sqlservercentral.com/Forums/Topic1354387-391-1.aspxYes Gail, rollback script is what I need.Can you pls help on this? Just a sample SQl Script will do.ThanksWed, 05 Sep 2012 03:17:20 GMTJunglee_Georgehttp://www.sqlservercentral.com/Forums/Topic1354387-391-1.aspxRolling the change back is probably a good idea...See - [url]http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx[/url]The rollback script will just be an ALTER PROCEDURE with the definition of the proc prior to the change that you made.Wed, 05 Sep 2012 03:12:37 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1354387-391-1.aspxSurely just remove the WITH (NOLOCK) hints in your stored procedure?Or am I missing something?Wed, 05 Sep 2012 03:10:34 GMTderek.colleyhttp://www.sqlservercentral.com/Forums/Topic1354387-391-1.aspxHiI have a simple stored procedure having a select statement.Recently I added a NOLOCK to the table name in the SP.My boss now wants a rollback script to be added in SP to go back to the previous version, ie, version in which NOLOCK is not there in the SP.Any help is gratefulWed, 05 Sep 2012 02:59:21 GMTJunglee_George