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 |
|
chinni1978
Starting Member
2 Posts |
 Posted - 2011-02-01 : 12:23:59
|
| i am looking the script for the below requirment.script to trace all the user information along with time(at what time the user is connecting) to the particular database in sql server 2005 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-02-02 : 00:33:18
|
| did you try using 'SP_WHO2' |
 |
|
|
chinni1978
Starting Member
2 Posts |
Posted - 2011-02-02 : 02:49:22
|
| i am not looking for the users who connected at that moment i ran sp_who2. what i am looking is the script which it trace in a temp table that all the users information along with time even we are not in a shift. |
|
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2011-02-02 : 05:03:59
|
| I never tried but I feel that you can use logon triggers for auditing. |
|
|
|
|
|
|
script for tracing the users