Is there any way to encrypt SQL stored procedures that actually works? I know about WITH ENCRYPTION and I also know it can be hacked. I have seen one program out there called SQL Shield but it is very expense. Are there any other ways to do it?
Printable View
Is there any way to encrypt SQL stored procedures that actually works? I know about WITH ENCRYPTION and I also know it can be hacked. I have seen one program out there called SQL Shield but it is very expense. Are there any other ways to do it?
You may consider using an ActiveX DLL, which can be referenced from a stored procedure in SQL Server to in turn encrypt your stored procedures. For further details you may need to perform a search or wait for someone more experienced with this to reply, but as far as I can tell, that would be the strategy.