Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Finding Login idle time

    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...

  • RE: Finding Login idle time

    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

Viewing 2 posts - 1 through 2 (of 2 total)