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?

  • May 11, 2013 at 12:23 pm

    #1614395

    select *--b.name, a.last_execution_time

    from sys.dm_exec_procedure_stats a

    --inner join sys.objects b on a.object_id = b.object_id

    where DB_NAME(database_ID) = 'SQL_Admin_DB'

    :cool:Appu