Any free tool to encrypt stored procedure/function & triggers

Question

Any free tool to encrypt stored procedure/function & triggers

Vladimir Sim

Ten Centuries

Points: 1310
More actions
June 7, 2006 at 4:51 am

#103175

Hi,
Anyone know of any free tool to encrypt SQL2k stored prcocedures/function and trigger ?
Native sql2k encryption can be crack by third party tool.
Thank you

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ian Yates SSCoach Points: 19738 More actions · Answer 1

I haven't tried it but I had heard that you can simply delete the text of the stored proc from the syscomments table. Thus the compiled version is still there but there is no text version. I have no idea what SQL does if it wishes to recompile the proc

Vladimir Sim Ten Centuries Points: 1310 More actions · Answer 2

Hi,

Thank for the feedback. I know that we can just remove the syscomment

but there is still tool to reverse back the code, hence not safe.

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 3

I've heard that the SDK for SQL Server has some fairly powerful encryption tools that 3rd part software will not be able to crack.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)