Home Forums SQL Server 2005 SQL Server 2005 Strategies How can i know which stored procedure is executed when and by which program? RE: How can i know which stored procedure is executed when and by which program?

  • November 26, 2007 at 6:29 am

    #753999

    zeeshan malik (11/26/2007)

    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

    Unless you were running a trace, you will not be able to find this out :(. Transaction logs contain a lot of information, but they do not store information about stored procedure executions.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software