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 |
|
issammansour
Yak Posting Veteran
51 Posts |
 Posted - 2007-04-20 : 02:54:23
|
| hi,I am a new user to SQL convert my business application from VFP. I am bulding my new application depending on stored procedures. My questions as follow:-- Is there a way to stored procedures encryption?- How to products my data structureregards |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-20 : 03:08:19
|
| "Is there a way to stored procedures encryption?"Presuming you mean you want to protect the source code (not the data) then you can do:CREATE PROCEDURE ......WITH ENCRYPTIONAS...however the encryption was weak (up to SQL 2000, I think SQL 2005 is stronger, but I'm not certain)"How to products my data structure"Not really. You can name all the columns silly things, but that just prevents folk like yourself from using it! Legal agreements are the only way. I started off being totally anal about that, but I no longer care. Our application is very complicated, and I don't think the Data Structure would be much use to competitors - well, they it might give them a good laugh I suppose!Kristen |
 |
|
|
|
|
|
data and SP encryption