jch001 Posted February 8, 2007 Posted February 8, 2007 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 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.