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 |
|
mdelgado
Posting Yak Master
141 Posts |
 Posted - 2002-07-26 : 15:39:29
|
| I just accidentally inserted a 'GO' statements near the top of my stored procedure and ran the alter proc command.Now everything that was below the command has disappeared.Can anyone help me retrieve it?Thanks... |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-07-26 : 15:43:08
|
| Restore from a database backup that would have the correct version and then sp_helptext to get the code you lost....<O> |
 |
|
|
mdelgado
Posting Yak Master
141 Posts |
Posted - 2002-07-26 : 15:45:38
|
| I don't have a backup, I created the database 2 days a ago.Please tell me theres some way to retrieve this! |
|
|
|
JohnDeere
Posting Yak Master
191 Posts |
Posted - 2002-07-26 : 16:11:32
|
| I think a restore is the only wayLumigent has a program called log explorer that might be able to look at the log, but I have no experience with this product. I have just read the marketing material.Lance Harra |
|
|
|
|
|
|
Help... Restoring an altered Sproc.