Encryption Store Procedures in Bulk in Mssql express 2008.
-
hi all, i have developed an application in vb.net with Mssql Express 2008 which has about 600 store procedures and 200 tables. All are working fine. now i want to install me app to my client (end user) and want to hidden my database from any one other than me.i know how to encrypt a sp. my problem is how i encrypt 600 SPs. if i do it one by one it will be a very big job. kindly suggest me suitable solution. Thanks
rmshah Developer
-
hi all, i have developed an application in vb.net with Mssql Express 2008 which has about 600 store procedures and 200 tables. All are working fine. now i want to install me app to my client (end user) and want to hidden my database from any one other than me.i know how to encrypt a sp. my problem is how i encrypt 600 SPs. if i do it one by one it will be a very big job. kindly suggest me suitable solution. Thanks
rmshah Developer
If you know how to encrypt a proc then write a script to encrypt each proc in your database, it is a simple loop process. Get a list of procs from the system information_schema views!
Never underestimate the power of human stupidity RAH
-
If you know how to encrypt a proc then write a script to encrypt each proc in your database, it is a simple loop process. Get a list of procs from the system information_schema views!
Never underestimate the power of human stupidity RAH