InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 18:02:29 GMT20http://www.sqlservercentral.com/Forums/Topic1372569-391-1.aspxRestore the database to a test server (not to the same server that the database already exists); extract the stored procedure code and permissions on the stored procedure; put the restored database offline or detach; run the extracted scripts on the required database and grant require permissions.Tue, 16 Oct 2012 21:19:43 GMTSiva Ramhttp://www.sqlservercentral.com/Forums/Topic1372569-391-1.aspxRestore a backup copy of the database and extract the correct procedure from that copy.You could set up a DDL trigger to capture this kind of changes into a table. Unfortunately, setting it up now that the damage is done won't help, but will save the pain next time it happens.Mon, 15 Oct 2012 02:21:56 GMTspaghettidbahttp://www.sqlservercentral.com/Forums/Topic1372569-391-1.aspxHello, someone executed accidentally old script in a database , have any way to get back date procedure script . if have, please reply me.ThanksMon, 15 Oct 2012 00:38:41 GMTdeepaktyagi84