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
 General SQL Server Forums
 New to SQL Server Programming
 2 copies of SP

Author  Topic 

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2006-10-05 : 16:48:52
I have 2 copies of the SP i work with. An original one and a backup. I usually work with the backup. Is there any way to update the original after updating the backup?. I usually forget what I have changed in the end of the day.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-10-05 : 17:06:46
Why don't you just execute your script using the original name:

ALTER PROC SprocName
...

Tara Kizer
Go to Top of Page
   

- Advertisement -