January 11, 2011 at 5:30 am
I am preparing a script to create a stored procedure (with encryption) in client machine.
I don't want to show the code to anybody. So I want to prepare a script in Encrypted format to create a stored procedure.
Could you please help me ....
Thanks in Advance.
January 11, 2011 at 7:30 am
Take a look at the create procedure syntax. I think what you are saying is that you want to prevent most users from seeing the sql of your proc.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 11, 2011 at 8:33 am
A few things.
First, your code is copyrighted automatically, so users can't re-use it legally. That's the best way to handle this.
Second, the "with encryption" hides the code, but a short Google search will easily find ways to reverse engineer it. So it's somewhat a waste of time.
Third, we could argue, and possibly you'd be write, but 99.99% of the time the code you've written isn't anything that's really proprietary. Your client should be paying you to do things because you've done the work. Structure the cost based on your work and don't worry about hiding the code.
January 12, 2011 at 1:34 am
Thank you ...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply