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 |
|
JeffS23
Posting Yak Master
212 Posts |
 Posted - 2008-02-19 : 10:52:19
|
| I need to roll back a stored procedure change I just altered. By mistake, I made a change to a Stored procedure and wish to roll it back to the version I had mere minutes ago. Is this possible. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-19 : 10:59:16
|
| Not unless you have version control at place.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
JeffS23
Posting Yak Master
212 Posts |
Posted - 2008-02-19 : 11:00:07
|
| What is version control at place? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-19 : 11:00:15
|
| Dont you have a version control system like SVN or VSS? If yes, you can get older versions from it. |
|
|
|
JeffS23
Posting Yak Master
212 Posts |
Posted - 2008-02-19 : 11:06:24
|
| Where can I find this out? Is this a seperate product or something built in SQL? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-19 : 11:09:52
|
| Its a seperate product. Most companies use this for version controlling mechanism wherein it stores all versions of your code and can help you to retrieve any version with ease. Its like a central repository. You need to add your code to this after each set of change. |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2008-02-19 : 11:27:28
|
| If you have a backup copy of your database, you may be able to get it back from there. |
|
|
|
|
|
|
Rolling back a Stored Procedure