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 ?