Post reply

How to check the status between a table and a stored procedure

  • September 21, 2006 at 7:52 am

    #62280

    Is that any system stored procedure and tool in sql server 2000 which can check the status of table and the stored procedure is currently running against the table in real time. I do not want to use the profiler

    Thanks

  • September 21, 2006 at 9:16 am

    #661786

    What do you need to monitor exactly?

  • September 21, 2006 at 11:26 am

    #661822

    The scenario is there are a few stored procedures running against a few tables performing select, insert, update or delete actions. Without using profiler, how can I monitor all the currently running process to know which SP is running against which table? Of course, the more info, the better

  • September 21, 2006 at 11:33 am

    #661823

    Can't monitor that.  The only you can do something remotely close is to make an audit table.  Then code the inserts in the sp to the audit table.

Viewing 4 posts - 1 through 4 (of 4 total)

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