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 |
|
kennetu
Starting Member
33 Posts |
 Posted - 2010-01-22 : 07:11:59
|
| Hi all,Can someone help me with a documentation/checklist on how I can enable Auditing for Logons only in SQL Server?Thanks for your usual support.Regards,Kenneth. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-22 : 08:05:12
|
| There is a setting in the Server's Properties to log Failed and/or Successful logins to the SQL Log. Is that the auditing that you wanted? |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-22 : 08:19:35
|
| Using that information , you can dig in deeper using Profile to gather activityJack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-01-31 : 09:32:07
|
| Well there is C2 auditing in SQL 2005 if you are looking to audit detailed activities but you have to watch out for logs it creates. |
|
|
|
|
|
|
How to enable Auditing for Logons in SQL Server