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 |
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
 Posted - 2001-02-06 : 17:58:24
|
| OK guys. My turn to ask a question.I create my stored procs in text files so I can keep them in source safe. I use the "WITH Encryption" flag to prevent them from being edited in Enterprise Manager. This works great.To deploy them from my dev server to my live server, I used the "Generate Scripts" feature in enterprise manager which created scripts like exec(decrypt(0x02B46FD9D3BF940CF6CDF1EEF76B1D99A)) (obviously a lot longer)...in SQL 7.0 BUT......in SQL 2000 it doesn't do it.It generates a message saying that it cannot script due to encyption./****** Encrypted object is not transferable, and script can not begenerated. ******/I don't like the thought of having to execute my 120 + scripts against my live database just to deploy my application, generating scripts is so much easier.It is becomming a problem as we are migrating all or servers to SQL 2000.Any thoughts on a solution or workaround ?MerkinEdited by - Merkin on 02/06/2001 18:16:47 |
|
|
|
|
|
Encrypted Stored Procs