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.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2013-07-01 : 06:28:04
|
| Hi allI have Created Stored procedure in SSMS 2008.Unexpectedly this proceudre has been Altered.is there way to get previous Script.i have tried to Restore my entire database.(this is not suitable for me)i need to get the before altered script.pls explain the way. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-01 : 06:32:03
|
| Nope. No way until you either have the previously created create procedure script in some version control (like VSS,TFS) or you've an earlier backup of the database before the altering happenedIf you've latter you can use it to restore a new copy of the db, then copy only required procedure to your database and then drop the other copy.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-07-01 : 10:39:24
|
| When retoring a database it does not have to be named the same. So if you have a database MYDatabase you could restore it to MyDatabase2.djj |
|
|
|
|
|
|
How to Get the Alter Procedure Script in Sql serve