August 7, 2008 at 2:46 pm
all the interaction between my application and database are handled through stored procedure(s) . The database is sql 2000. I am just wondering if there is a way to find out which stored procedure(s) has been execute from my application. I would appreciate any command or suggestion.
August 7, 2008 at 3:26 pm
SQL Profiler can tell you this.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 7, 2008 at 3:38 pm
This is how I do it: I write a log record in a table when it starts and updates the column [endtime] in that logtable when the procedure finishes. If you're interested, I'll send you an example.
The following trick shows the current stored procedure being executed. It works in 2005, not sure if it works in 2000:
select object_name(@@procid)
Wilfred
The best things in life are the simple things
August 7, 2008 at 3:41 pm
I normally use SQL Profiler when I want to find out what is running.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply