If I use the WITH ENCRYPTION command in SQL 2000, how can I generate a sql script outputting the now encrypted Stored Procedure. If I generate a sql script using the "Generate SQL Scripts" in Enterprise Manager, there will be a error message displayed that the code is not transferable. I believe you also get the error message if you open the Stored procedure in Enterprise Manager. What I have been doing so far is encrypting Stored Procedures using SQL 7 then generating a script using the "Generate SQL Scripts" in Enterprise Manager. I can gen run the script in query analyzer to create the encrypted Stored Procedures in SQL2000.
An option is to leave the stored procedures in a readable format with the WITH ENCRYPTION command in the stored procedure and let SQL encrypt it when run but I would prefer the code to be secure.

Any ideas on how to get around this problem in SQL2000 ?

To my knowledge we need to take a backup or generate the script and keep it before using With Encryption in SP. I don't think there is a way to generate the script after encrypting the SP.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com