Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. How can i know which stored procedure is executed when and by which program? [modified]

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

Scheduled Pinned Locked Moved Database
databasequestionhelpcareer
2 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • Z Offline
    Z Offline
    zeemalik
    wrote on last edited by
    #1

    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 -- modified at 12:21 Monday 26th November, 2007

    To do what can be done is a Intelligent Job and to do what should be done is a Genious Job done is a Genious Job

    P 1 Reply Last reply
    0
    • Z zeemalik

      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 -- modified at 12:21 Monday 26th November, 2007

      To do what can be done is a Intelligent Job and to do what should be done is a Genious Job done is a Genious Job

      P Offline
      P Offline
      Pete OHanlon
      wrote on last edited by
      #2

      You need to look at using SQL Profiler to identify what's going on down at the database level. It won't tell you exactly which program calls the SQL, but it will tell you what SQL is hitting the database and who is doing it? Take a look at this[^] article for details. Now a request - please don't put it's urgent in a post. They are all urgent to somebody, and this doesn't help anybody.

      Deja View - the feeling that you've seen this post before.

      My blog | My articles

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups