 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Security / January 2006enable security auditing ..how ?
Came across this on the checklist for best practises Enable security auditing . Enable security auditing of Sysadmin actions, fixed role membership changes, all login related activity, and password changes. . After selecting appropriate auditing options, you should script the audit, wrap it in a stored procedure,and mark that stored procedure for AutoStart. But dont really know how to go about it ? Is this part of Profiler ? And if so, will it be an overkill to run on a continuous basis on a server that may be highly transactional ? Which checklist and which version of SQL Server?  SignatureMike http://www.solidqualitylearning.com Disclaimer: This communication is an original work and represents my sole views on the subject. It does not represent the views of any other person or entity either by inference or direct reference. > Came across this on the checklist for best practises > [quoted text clipped - 9 lines] > if so, will it be an overkill to run on a continuous basis on a server > that may be highly transactional ? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.