Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 4 down vote favorite

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?

share|improve this question

1 Answer

up vote 7 down vote accepted

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.

share|improve this answer
2  
+1 I wholeheartedly agree with this answer. "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." I wish I could +10 that snippet. – Thomas Stringer Aug 24 '12 at 2:44

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.