Thursday, November 28, 2013

Unlock a stored procedure


we get a stored procedure from network but it is locked



Hello Seyed,


Locked? I guess you mean the SP is shown up in SSMS object explorer with a lock icon? This means the stored procedure is encrypted and there is no official way/tool to decrypt the SP. You have to ask the developer of the SP to give you the code.




Olaf Helper


[ Blog] [ Xing] [ MVP]

No comments:

Post a Comment