by Sean Jackso » Sat, 09 Sep 2000 09:01:00
by Microsof » Sat, 09 Sep 2000 09:46:46
Sean,
In the Profiler, there is a data column called object_id. When you
monitor SP:StatementStarting or SP:StatementCompleted the object_id will be
shown. You could filter and only trap statements for the object_id of your
stored procedure.
Mark
Quote:> I need an SP running all the time.
> I dont want to set the startup option for a master SP.
> Can I determine if an SP is running or not somehow???
by Tibor Karasz » Sat, 09 Sep 2000 16:27:39
I guess that you can interrogate the sysprocesses table. And/or use the DBCC
INPUTBUFFER statement.
--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.
See Neil Pike's FAQ at: http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
Quote:> I need an SP running all the time.
> I dont want to set the startup option for a master SP.
> Can I determine if an SP is running or not somehow???
Hi,
Please forgive me if this is a daft question.
How can I determine what service pack level is installed on my SQL Server?
TIA,
Michael
3. fixed field export in dts skiping nulls
4. Error running SP as Job but not when run from Query Analyzer
5. Will Delphi Run On Alpha with NT 3.51?
6. How Can I Determine if SP is running?
8. How to determine if a sp is running ?
9. DTS process needs to be able to run while I am not logged into ODBC Datasource
10. SP runs from QA but not from job
12. SP runs in one processes but not in another