how to encrypt and decrypt stored procedure in sql server 2000

[M Ramesh]

I want to encrypt my stored procedure. How can i do this and revert back also. anybody help..

[Mark J Miller]

Here's how to encrypt the procedure: CREATE PROCEDURE myTestProc @Id INT WITH ENCRYPTION AS SELECT @@SERVERNAME GO But you have to save the source code in a script file somewhere. There is no way to decrypt the source. Not even for sysadmin or dbowner.

Mark's blog: developMENTALmadness.blogspot.com

[M Ramesh]

thanks a lot..