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 |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
 Posted - 2005-03-16 : 06:08:41
|
| hello,I just finished working on a trigger and accidentally deleted it, because i worked very late into the night and wasnt concentratingIs there a way to retrive it ?afrika |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-03-16 : 06:17:04
|
| I think it is not possible until you saved and took back upMadhivananFailing to plan is Planning to fail |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-03-16 : 06:27:25
|
| Ok, thanksAm trying to recreate the script, from the posts i made here on this forumGuess this forum is my temporal back up :-) Afrika |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-03-16 : 06:33:48
|
quote:
Originally posted by afrika
Ok, thanksAm trying to recreate the script, from the posts i made here on this forumGuess this forum is my temporal back up :-) Afrika
Yes, this is the temporal back up where you can get the solution whenever you need  MadhivananFailing to plan is Planning to fail |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-16 : 09:06:40
|
| Can you restore the DB to point in time (using transaction log)?If so you can use SP_HELPTEXT 'MyTrigger' to get the source code of the triggerAs long as you didn't use WITH ENCRYPTION ... :-)Kristen |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-03-16 : 09:19:41
|
| thanks KristenBut i just recreated it from the posts i have on this forum |
|
|
|
|
|
|
Is there a way to retrieve deleted triggers