Conditional SP Encryption

[EdwinGene]

Is there any way to conditionally encrypt a stored procedure when creating it? For example, running the sp script against the development server would not encrypt the sp, but running the same sp script against the production sever WOULD encrypt the sp.

Is this possible?

Thanks.

 

[Catadmin]

Not that I'm aware of. Encryption is either on or off. No in between.

Sorry.



Catadmin - MCDBA, MCSA
Beware the error of pre-emptive poultry inventory!