Encrypted Triggers.

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!
-AlanHi, 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
--