Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
essence831
Starting Member
1 Post |
 Posted - 2008-06-13 : 10:10:22
|
| Hi there, I was wondering if anyone knows how to do it. We have a couple of servers, each of which hosts tons of databases. I am trying to write a script to check whoever has logged into any database within the past week, for example (not just the current users). I have tried 'sp_who' and 'sp_who2' but they are not meeting my needs. Appreciated!! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-13 : 11:22:55
|
| You need to create Database level trigger using logging tables. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-14 : 17:50:44
|
| Or use third party sql auditing tool. |
|
|
|
|
|
|
script to check the history of user logs