jch001
Member
We are about to go into production on our SQL Server 2005 database, we would like to hide all our stored procedures from our Clients eyes.
Do you know of a way to apply "WITH ENCRYPTION AS" to all the stored procedures in a database without opening each one individually, or to setup a script to do this?
Finally, I understand that this method can easily be reversed, by doing a simple procedure. We have used the .NET 2.0 DLL feature for a few of our procs but, we are unsure what method to use. Any recommendations?
many thanks
Do you know of a way to apply "WITH ENCRYPTION AS" to all the stored procedures in a database without opening each one individually, or to setup a script to do this?
Finally, I understand that this method can easily be reversed, by doing a simple procedure. We have used the .NET 2.0 DLL feature for a few of our procs but, we are unsure what method to use. Any recommendations?
many thanks