Prevent access to code 1

[SpiritOfLennon]

Hi,
Can anyone tell me if it's possible to create compiled T-sql code on SQL server so that new other parties can steal your code?


SOL
I'm only guessing but my guess work generally works for me.

 

[SQLSister]

YOu can encrypt stored procedures but the encryption is relatively easy to break, so my answer would be no.

If this is a problem for you then create your t-sql code inteh application and compile the application code. This of course will make the application run less efficiently, but that's the trade-off for securing your code.

Questions about posting. See faq183-874

 

[SpiritOfLennon]

Thanks for that sqlsister, when you say easy to break how easy? It's only small programs to augment an existing system and I'm only really trying to stop other consultants stealing my ideas, so prevention against "casual theft" was more the approach.

SOL
I'm only guessing but my guess work generally works for me.

 

[SQLSister]

Search this site for decrypt stored procedure and you will see how easy it is.

Questions about posting. See faq183-874

 

[SpiritOfLennon]

That answers that. Thanks again SQL Sister

SOL
I'm only guessing but my guess work generally works for me.