ManoharV
SSCommitted
Points: 1730
More actions
February 18, 2009 at 6:23 am
#131076
Can anybody help me to encrypt whole stored procedures for a particular database .
I know for single procedure using WITH ENCRYPTION keyword
Thanks in advance
Manohar V
Jack Corbett
SSC Guru
Points: 184393
February 18, 2009 at 6:54 am
#945860
You would need to go through each sp and add the WITH ENCRYPTION option to the script. If you always want to create procedures with encryption you could create a template that you always use to create procedures.
Jack CorbettConsultant - Straight Path SolutionsCheck out these links on how to get faster and more accurate answers:Forum Etiquette: How to post data/code on a forum to get the best help Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply