Post reply

Hi i need to do a trace of a procedure that is called from another that is encrypted

  • May 17, 2005 at 5:02 pm

    #69083

    Hi i need to do a trace of a procedure that is called from another that is encrypted, is possible to do tha?

    my company doesnt allow to decrypt the procedures, because that is wrote by contract.

    thanks friends...........

  • May 18, 2005 at 2:52 am

    #559507

    You could run profiler and capture the sp:StmtStarting event. That will show you every statement executed inside the stored proc, even if it is encrypted.

    That way, you'll be able to capture the calling statement for the procedure you want to trace.

    HTH

    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

  • May 18, 2005 at 9:38 am

    #559630

    Thanksssss Master  i didt know that trick

     the force is with you

  • May 18, 2005 at 9:06 pm

    #559764

    Please note, you need to have ADMIN rights to run trace.


    paul

Viewing 4 posts - 1 through 3 (of 3 total)

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