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 |
|
dnf999
Constraint Violating Yak Guru
253 Posts |
 Posted - 2007-06-13 : 09:36:51
|
| Hi As a newbie to DBA type tasks, how can I trace who has accessed the server/database. I know there is a SPID in the Server log but what does this represent?Thanks! |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-13 : 09:42:41
|
| Use sp_who or sp_Who2 stored proc.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
dnf999
Constraint Violating Yak Guru
253 Posts |
Posted - 2007-06-13 : 09:55:50
|
| That's for current users right?How about in the past. I.e. see how accessed/used the server 1 month ago. Is this possible? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-13 : 11:09:51
|
| No unless you use auditing tool. |
|
|
|
dnf999
Constraint Violating Yak Guru
253 Posts |
Posted - 2007-06-13 : 11:22:38
|
| auditing tool?Such as? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-13 : 11:33:51
|
| Lumigent's Audit DB. |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-06-13 : 12:05:09
|
| also, if you have set under SQL Server Security to log both successes and failures for all logins, you don't need to use auditdb.C2Audit tracing is an overkill in this. If the server is heavily used it can create about 1GB log in under a day.RegardsParesh MotiwalaBoston, USA |
|
|
|
|
|
|
Tracing users of a database