MS SQL Server - Copying encrypted stored procedures.

Author

Copying encrypted stored procedures.

nickwilson.nick@gmail.com

2006-03-24, 8:23 pm

I have several stored procedures, created in a development environment,
that I need to move to a 'QA' environment, and then in turn, to various
production environments.
When I move these stored procedures, I would like to encrypt them,
using the 'WITH ENCRYPTION' clause.

My question is, how do I copy these stored procedures from development
to their target SQL server environment in an encrypted state?

Up until now, we have been moving them by generating an SQL script and
then executing that script on the target server. I have tried this
using a script with 'WITH ENCRYPTION' specified within it, but it
doesn't appear to work when I try and execute that script on the target
server.

Any advice would be greatly appreciated.

Nick.

Jens

2006-03-25, 3:23 am

HI,

you either need the sources for the procedure or if not accessible or
recoverable you can to to decrypt the procedure text (which isn=B4t
actually hard and can be found in tons of articles on the internet).

HTH; Jens Suessmeyer.

---
http://www.sqlerver2005.de
---

Sponsored Links