How can i prevent decryption in SQL Server procedures

WePython 1 Months+

I came across in internet tool to decrypt procedures, I checked my database with this tool to decrypt my procedures and it works fine, now the problem is I wish to prevent this kind of tools from decryption of my procedures.

Any methods to prevent this kind of tool from decryption of my procedures?

-----------------Answer-----------------

SQL Server does not actually encrypt the definitions of objects, it obfuscates them instead. It is a bit misleading I am afraid as all it is really doing is making it unreadable to humans [excluding the use of tools as you previously mentioned].

Also SQL Server needs to know the contents of the procedures, functions & views for when it needs to recompile the execution plan etc... so real encryption would prevent SQL Server from being able to do this. As a result this is not possible.

My best recommendation if you are worried about IP & copyright is to secure your software with Licensing. You may not be able to prevent someone from reverse engineering your code but you can sue the pants off them if they do.


Previous : EXISTS and sub-query cost
Next : Error updating sql server geography type in trigger