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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2006-10-11 : 20:13:22
|
| Hi thereI got this login which is undocumented in our system. Is there anyway to know whether someone being used this account or not for the last 30 days or something? I got an AUDITING turn on but just for FAILED only though.I am appreciated your comment.Thanks |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-11 : 22:35:46
|
| if you don't want to turn on the audit for success, here's an ideacreate a job that runs at n-interval, that records the entries in the sysprocesses (you can filter for loginame, machinename, database, etc)... you can set not to log existing entries to meet your goalHTH--------------------keeping it simple... |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-10-11 : 22:45:38
|
| Remove it and see who screams.CODO ERGO SUM |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-10-11 : 23:53:26
|
| So you guys saying that we should turn this on for BOTH (failure and successfull)? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-12 : 00:02:25
|
atleast for this purpose? otherwise explore other approach, there is more than one way to skin a cat eh? --------------------keeping it simple... |
|
|
|
|
|
|
Finding the usage of login