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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2008-05-13 : 10:25:35
|
| Hi l'd like to find the list of logins and when they were last used this is for SQL 2000 i think this can be done on 2005 in the sys.server_principals but how do i do it in 2000 ? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-13 : 10:31:01
|
| Query : syslogins |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2008-05-13 : 10:47:15
|
| Hey thanks for this i was on the right track what i would like to know is when that login was last used. I see 3 date columns 'created' 'updated' and 'accdate' now i have created a new login and i want to know when the person last used it to login it. I need to do a audit on olf loginsNone of these columns give me this info is there any sys view or table that can in 2000 ? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-13 : 13:47:52
|
| You can create Server level Trigger and capture SUSER_SNAME() . |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-14 : 22:59:46
|
| Or enable sql login auditing. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-15 : 17:22:59
|
quote:
Originally posted by rmiao
Or enable sql login auditing.
This is good option. |
|
|
|
|
|
|
List of Logins