Show Lock Symbol on SP

Posted by Navi1478 under Sql Server on 4/26/2013 | Points: 10 | Views : 950 | Status : [Member] | Replies : 1
Dear Team
Plz help me ..
I restored database Database restored propely through .bak file
but in storedprocedures show lock symbol i can view this storedprocedure plz help me


Posted by: Jitendrasoft09 on: 4/26/2013 [Member] [MVP] Starter | Points: 25

Your procedure is created with Encryption so the reason the user can not see the procedure, You have to give the permission to the user to see the encrypted procedure, please find below link that would be helpful for you while doing practically.

Jitendra Kumar
If my post helps you, plz mark as an answer.

Navi1478, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response