Unlocking stored procedures

Question

Post reply

Unlocking stored procedures

rahuldhawan2007

Mr or Mrs. 500

Points: 596
More actions
November 29, 2013 at 5:27 am

#283040

Hi All
I have a MLM database in which some stored procedures are locked. Could you please guide me how to unlock a lock stored procedure.
Thank you in Advance

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

LutzM SSC Guru Points: 107049 More actions · Answer 1

Check with the database owner if the permission to modify those stored procedures can be granted.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Aram Koukia SSCommitted Points: 1521 More actions · Answer 2

I assume By "Locked" you mean Encrypted? are you seeing this little Lock icon over your stored procedures names?

If that is the case, I dont think you can Decrypt them in SQL Server, or you can probably look online for some tools to do that / hack that for ya ...

[font="Courier New"]Aram Koukia: http://www.koukia.ca[/font]

rahuldhawan2007 Mr or Mrs. 500 Points: 596 More actions · Answer 3

Hello Guys i got a way to decrypt sql. we can decrypt sql from the following software

http://www.devart.com/dbforge/sql/sqldecryptor/download.html

Jeff Moden SSC Guru Points: 1004376 More actions · Answer 4

rahuldhawan2007 (11/29/2013)
Hi All
I have a MLM database in which some stored procedures are locked. Could you please guide me how to unlock a lock stored procedure.
Thank you in Advance

Why do you need to get into someone else's stored procedures without their permission? I'm not liking the smell of this at all.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

rahuldhawan2007 Mr or Mrs. 500 Points: 596 More actions · Answer 5

@jeff Moden

Hello Jeff i understand your concern. i'm not trying to hack it. actualy i'm dealing with a project created by a former employee of the company. Now that employee has left job.

Jeff Moden SSC Guru Points: 1004376 More actions · Answer 6

rahuldhawan2007 (11/30/2013)
@Jeff Moden
Hello Jeff i understand your concern. i'm not trying to hack it. actualy i'm dealing with a project created by a former employee of the company. Now that employee has left job.

Understood. In that case, I'd institute proper procedures for code promotion in the future. No one but the DBA should promote code, there should be a code review, and nothing goes to production until it's been checked into source control in an unencrypted format because THAT's where the peer review code should come from. 🙂

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)