February 3, 2008 at 11:13 pm
Hi just want to ask if i can compile my scripts in dll form then add it to the dll's in sql so that my script can be secured from viewing??
"-=Still Learning=-"
Lester Policarpio
February 4, 2008 at 12:05 am
Not really possible. You can encrypt your stored procedures though by specifying WITH ENCRYPTION on them. Alternatively you could put your code into .NET assemblies that you attach to SQL Server, but that's for 2005 only (I guess you have 7 or 2000 since you posted in this forum).
I have seen stored procedure decryption routines as well so don't rely on it 100%. You could move all of the code to your application and include as a comment in each query
--password
This way someone cannot use SQL Profiler to trace the execution of your statements as SQL Server explicitly does not allow anyone to see the text of a command that has the word "password" in it.
What's in your code that you need to protect? Normally it's the data that's secret/special.
February 4, 2008 at 3:26 am
Thank you for your nice explanation the reason why i ask this kind of question is that when i used xp_smtp_sendmail it is in dll form and is added as extended stored proc so i thought maybe it is possible since i created several scripts I want to test if i can put it in a dll then add it as an extended stored proc..
"-=Still Learning=-"
Lester Policarpio
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply