August 19, 2011 at 4:22 am
Hi there,
For reasons not explained further I like to know if there have been any Active Connections in a database for, say, the last 10 minutes, and if so, how many could these be. I can find a lot of scripts telling me about CURRENT active connections, but have yet to find a way to lookup a history of active connections.
Any hints?
Greetz,
Hans Brouwer
August 19, 2011 at 9:35 am
Unless you have some kind of Audit running, you probably wont see any from the past. The only place you might find if anyone logged on to the DB is the Security log of the OS. I cant remember where else you could see that.
sp_who2 will have connection that are still valid. (Sleeping mode) and you can see the last time the connection executed something.
-Roy
August 19, 2011 at 9:51 am
agree with previous post... you might be able to infer who was connected by looking at the default trace to see the most recent activity.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply