Viewing 2 posts - 1 through 2 (of 2 total)
Steve:
Out of curiosity, what exactly do you mean when you say system tables aren't supported? I have not heard this before.
The reason I ask is because if you look...
August 23, 2001 at 1:09 pm
#417764
I think this would work too. It returns the amount of time since the last batch in minutes:
select spid, DATEDIFF(mi, last_batch, getdate()) from master..sysprocesses
Chad
August 22, 2001 at 2:58 pm
#417744