Show Lock Symbol on SP

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




Responses

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

Up
0
Down
Dear,
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.
http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/what-does-the-lock-icon

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