Post reply

SSMS Stored procedure help

  • May 2, 2013 at 5:49 pm

    #394712

    Hi professionals.

    We have software written by a 3rd party vendor and I am trying to read one of there stored procedures under "programmablity", "stored procedures" and then right clicking on modify procedure.

    The problem is modify is grayed out and i cannot click it.

    So my 2 questions are

    1: Can this be read in any way or is it not possible.?

    2: How can I compile one of my procedures so that I can have it grayed out too.?

    Thanks

  • May 2, 2013 at 5:56 pm

    #1612056

    There are a couple of ways that can be grayed out, but to get rid of a series of Q&A... are you the sa on the box or DBO of the database? If not, ask someone with sa to see if they can script it.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • May 2, 2013 at 5:59 pm

    #1612057

    hi there

    Yes I am the sa on the box

    thanks

  • May 2, 2013 at 6:11 pm

    #1612058

    Final check, what does it say when you rt-click -> Script Stored Procedure as -> Create To -> New Query Editor window?

    My guess is they most likely encrypted the procedures. That encryption can be broken, so don't take it to heart as a method to use (other than to annoy savvy DBAs), it's really to deter the rabble than to stop serious reverse engineering attempts. I won't post methods of unencrypting here for obvious reasons, but google will turn up plenty of information on that particular subject if you're curious.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • May 2, 2013 at 6:16 pm

    #1612059

    yeah it just comes up that the textheader is not available etc due to insufficient access rights so yeah looks like its encripted

    also my other question , how would I encrypt my own procedures in ssms

    thanks

    alan

  • May 2, 2013 at 6:23 pm

    #1612060

    CREATE PROCEDURE TestProc

    WITH ENCRYPTION

    AS

    ...

    GO

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • May 2, 2013 at 6:23 pm

    #1612061

    right i have figured out how to encrypt my procedures by doing

    alter procedure procedure name with encryption as

    bla bla bla

    now I have a procedure with a little padlock next to it and the modify is now grayed out.

    so my problem now is that I am the owner of this procedure but I cannot modify it because it is now encrypted and grayed out. is there any way round this

    thanks

  • May 2, 2013 at 6:26 pm

    #1612062

    alan_lynch (5/2/2013)

    so my problem now is that I am the owner of this procedure but I cannot modify it because it is now encrypted and grayed out. is there any way round this

    thanks

    Officially? Keep a copy of the source script text so that you can work on the procedure. TFS, Sourcesafe, pick a place.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • May 2, 2013 at 6:29 pm

    #1612063

    so does that mean my procedure I have encrypted is offically unreadable,editable even though I am the owner because I have not kept the original source???

  • May 3, 2013 at 4:53 am

    #1612141

    You can use any third party tool to decrypet encrypted procedure

  • May 5, 2013 at 3:32 pm

    #1612487

    Do you know of any free ones, when I have tried to look for some they all have to be paid for

    thanks again

  • May 5, 2013 at 4:55 pm

    #1612489

    Red Gate's SQL Prompt. 30 day, full-featured trial.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 12 posts - 1 through 11 (of 11 total)

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