Post reply

Using Profiler to obtain SQL executed by an encrypted Stored procedure

  • February 5, 2014 at 5:02 am

    #289202

    Hi Everyone,

    Is it possible to use SQL Server Profiler to viewthe SQL that is being run by an encrypted Stored Procedure?

    If not does any one have any ideas how I could do this?

    Regards

    David

  • February 5, 2014 at 5:46 am

    #1686160

    why don't you just decrypt the stored procedure instead?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 5, 2014 at 6:26 am

    #1686171

    Thanks for the reply.

    The user account that originally encrypted the Stored procedure no longer exists. Therefore do I need a 3rd party tool to decrypted the stored procedure?

    Regards

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

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