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 |
|
SalmanAhmed
Starting Member
5 Posts |
 Posted - 2004-11-07 : 16:20:23
|
| Hi,How do you handle encrypting sprocs when in development mode? Is there any quick and easy way to encrypt all sprocs whening pushing out a production build w/o manually adding the necessary script? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-07 : 16:27:21
|
| If you develop from scripts held in sourcesafe (as you should) then you can encrypt them during development too.Otherwise you can write something t ogo through all the sp scripts to add a "with encryption" before the "as".==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-08 : 02:05:23
|
| We put /* WITH ENCRYPTION */in our SProcs, and then just globally change them to remove the comment when we install them on production systems.Mind you, the SQL2K encryption is pathetic and a child of 4 could decrypt them in the blink of an eye ...If anyone has a comment-remover, and/or obfuscation, tool I woul dbe interested to hear of itKristen |
|
|
|
SalmanAhmed
Starting Member
5 Posts |
Posted - 2004-11-09 : 06:49:03
|
| hmm, that's not good news.But I guess 90% of people aren't even going to go to the efforts to do that (but maybe they are not the ones your hiding the sql from hehe) |
|
|
|
|
|
|
encrypting sprocs