|
Home > Archive > MS SQL Server > October 2006 > Encrypted Triggers.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Encrypted Triggers.
|
|
| Alan Wu 2006-10-24, 6:38 pm |
| Somehow, the encrypted triggers were missing in our production server.
Is there any way, without restoring old database, to recover them using
development server?
Thanks!
-Alan
| |
|
|
Hi, you will have to restore the database or find the script which
actually created them with encryption. AFAIK there is no way to script
encrypted triggers out of the database. If you are using SQL Server
2000 you might search at Google for some (unsupported) decrypting
mechanisms to hack the procedures. But there is (fortunately) no
official tool for this.
HTH, Jens K. Suessmeyer.
---
http://www.sqlserver2005.de
---
|
|
|
|
|