August 12, 2008 at 3:15 pm
Hi guys:
one of the SA wants me to investigate who is using the database often. At top of my head, I can not find a way to tell. Do you have any idea of this?
Thanks in advance
August 12, 2008 at 3:20 pm
Have you considered profiler or a serverside trace? If you don't mind your error log growing significantly, you could also set the option to audit successful logins. (found under server properties-security)
Of course, all of those require that users have their own individual logins. If they don't and there's a single application login, then it's going to be significantly harder.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 12, 2008 at 10:00 pm
Successful logins should be audited any how (it's the only way to gain non-repudiation), but a server side trace is best for this. There are 3rd party products that will also monitor at the network level and put shims in via an agent so a server side trace isn't necessary, but these aren't inexpensive choices.
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply