Process ID

[VBXL]

Is there anyway to capture a status of a process.

I want to find out if a process has started and finished from VB. Any Ideas


Xplain

 

[RickCole]

Not sure if this is what your looking for but the global variable @@spid returns you the current connection id from the server. Run the following query from the query analyser:

select * from master..sysprocesses where spid = @@spid

This will return lots of information from the sysprocesses table from within the master database. There are probably a few columns within this row including the status which may be of use to you from within you VB app.

Rick.

 

[VBXL]

Cheers

But i was looking for a command where i could see if a stored procedure had finished

 

[RickCole]

Not aware of anything like that.

What we have done at our site on auditing certain SP's is to have a SP_audit_table whithin the database. User id's, start and finish times and other useful data are written to this table whenever ths SP is started and finished.

Has proved to be very helpful in the past.

Rick.