encrypted sp- will it cause any blocks for any user?

right now, a store proc is just plain text.. we want to encrypt it.. will this  mean we have to have all users test it.. or encrypting does not affect any execution or functionality?

thanks
LVL 5
25112Asked:
Who is Participating?
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
it wont affect any performance. You wont be able to see the sp definition in case you use the sql profiler
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.