Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 recovering sp

Author  Topic 

mdhingra01
Posting Yak Master

179 Posts

Posted - 2007-03-22 : 23:13:46
I was working on editing a sp. I decided to cancel my changes and SQL server promted me to save changes. I clicked on no and my entire sp code is missing under the change I made. Even though I said to saving the change, it saved it and deleted all the other code in the sp. Does SQL server log history of the sp like DTS packages and is there a way I can recover the code from preceeding version of the sp
   

- Advertisement -