>Hi,
>
>We can Encrypt the Stored Procedures using "WITH ENCRYPTION " clause in the create Procedure statement.
>
>But my requirement is bit different.
>We have thousands of proc written. When I am sending these to my client I would like to encrypt them so that the source is safe with me. something like BULK Encryption of all user defined proedures.
>
>I have considered the following
>The Syscomments Table stores the information about this. So If I change the value in syscomments.status to 1, the procedure cannot be viewed in EM. but the same does not run. I this procedure is run once & then I hange the status it runs. I suppose this is because the compiled version is available..It is virtually impossible to run every proc.......... so this does not work for me ..........also I do not know how safe & advisable this might be.......
>
>can this be done.......how......Any ideas ...........??
>
>TIA
>
Hi Vipul,

It's not the answer to your question but WITH ENCRYPTION doesn't provide real protection for your stored procedure because there're free tools available that can decrypt them w/o any problem. Here's one them at http://www.geocities.com/d0mn4r/dSQLSRVD.html.