Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ssumma
Starting Member
2 Posts |
 Posted - 2012-02-10 : 13:09:58
|
| I've created a long query and update item and saved it as .SQL, I want to be able to send it to a college to run against his DB, but I don't really want him mucking with my statements and insterts. Is there a way to give him the .SQL (or some other form) , have it run but not be seen? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-10 : 15:47:56
|
| nope. not possible. .sql will contain actual code so he will be able to see it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
ssumma
Starting Member
2 Posts |
Posted - 2012-02-11 : 00:53:00
|
| Thanks, is there any other possibility or solution that might accomplish what I want to accomplish? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-02-11 : 06:59:37
|
direct connect to your college's DB to run the query
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-11 : 08:00:23
|
quote:
Originally posted by ssumma
Thanks, is there any other possibility or solution that might accomplish what I want to accomplish?
if you dont want to expose the code execute the code in db. then backup and send it across to friend for restoring it. you may choose to encrypt code if you want------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2012-02-11 : 12:58:33
|
| Encryption is weak though, so if your friend wants to unencrypt your work, e.g. to "steal" it, he can.We take all the spaces, comments, etc. out of our code on client systems just to further hamper people wanting to steal out code. You could obfuscate local variable names by changing them to something non-obvious.Downside is: All those things make it much harder to debug your code, on the target system, if you need to ...Depends how much trouble you want to go to really. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-12 : 12:18:20
|
quote:
Originally posted by Kristen
Encryption is weak though, so if your friend wants to unencrypt your work, e.g. to "steal" it, he can.We take all the spaces, comments, etc. out of our code on client systems just to further hamper people wanting to steal out code. You could obfuscate local variable names by changing them to something non-obvious.Downside is: All those things make it much harder to debug your code, on the target system, if you need to ...Depends how much trouble you want to go to really.
thats a good simple method  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
Hiding Query after building