User Job History - SQL Server 2000 Enterprise Manager 1

[P1A3]

Hi

Using SQL Server 2000 - Is there a way to view the actual stored procedure jobname initiated by a specific user with Enterprise Manager or possibly with a built-in sp using Query Analyzer.

I am tasked with finding out the name of stored procedures that are being used by remote executables and the code is not available to view the name of the stored procedure used. I thought I might just run the exe and watch for the user job to initiate on the server to find out the sp name. But, so far I don't see an actual stored procedure name associated with the job.

Thank you.

 

[nigelrivett]

Try using the profiler - you can trace what is called and all t-sql executed.

If you just want the command that is excuted on a connection then dbcc inputbuffer (spid) wil do it.
see

http://www.nigelrivett.net/sp_nrSpidByStatus.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[P1A3]

Thank you. Unfortunately, I don't have rights to use the trace utility, but it seemed like exactly what I needed. Too bad I'm in the type of corporate environment that would take months to get any new permissions granted for me.

I did go and look at the sp_nrSpidByStatus link that you sent and I tried to run it with 'all' behind it and just as is, but the procedure was not found:

Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_nrSpidByStatus'.

Do you think it's been removed from the server to prevent people running it?