Post reply

How can i know which stored procedure is executed when and by which program?

  • November 26, 2007 at 6:22 am

    #119632

    I want to know which stored procedures are executed in the last 24 hour in my database and i wish if i could also know about the program who called the stored procedure?

    OR

    I can know about a specific stored procedure that when it was executed last time and by which program?

    Please help...its urgent?

    Regards,

    Zeeshan Malik

  • November 26, 2007 at 6:51 am

    #754011

    Hi,

    The only way I know of to find out this information is by running the profiler and monitoring the execution calls as they happen. Since you haven't done this and are trying to find out when/who executed the SP in retrospectively I can't really help you. I'm not sure about SS2005 but in 2000 there was no way to achieve this. sorry

    Is someone after doing something they shouldn't have?

  • November 26, 2007 at 8:20 am

    #754072

    Please don't double post. It splits answers and wastes time

    Continue thread here please

    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 3 posts - 1 through 2 (of 2 total)

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