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 |
shaggy
Posting Yak Master
248 Posts |
Posted - 2013-02-19 : 03:10:11
|
Hi friends,I want to audit whichever login has logged on I can able to get the login failed details like (Password did not match) in error logbut specifically i need to audit logged on usersshould i need to enable trace so that it will be captured in error log.or any other approach is highly appreciated. |
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2013-02-19 : 03:14:39
|
By enabling security option in server properties i can able to get failed and successful detals in error logany other approach. |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-02-19 : 03:37:35
|
You can use SQL Server Profiler by the selection of Security Audit Event --Chandu |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2013-02-19 : 03:52:28
|
But all time profiler execution is impossible. |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-02-19 : 04:12:42
|
Do you wanted to know what users logged in at a particular time or wanted to trace all the users who are logged on. You can run the following query if you wanted to check what user logged on and what action is he performing at a given time. If you wanted to trace, you can get the info by many ways.SELECT d1.session_id, d3.[text], d1.login_time, d1.login_name,d2.wait_time,d2.blocking_session_id, d2.cpu_time, d1.memory_usage,d2.total_elapsed_time, d2.reads,d2.writes,d2.logical_reads,d2.sql_handleFROM sys.dm_exec_sessions d1JOIN sys.dm_exec_requests d2 ON d1.session_id=d2.session_idCROSS APPLY sys.dm_exec_sql_text(d2.sql_handle) d3 |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2013-02-19 : 04:21:38
|
Thanks srimani & bandiI want to automate the particular login to be audited so that in future i can able to track. |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
|
|
|
|
|
|