September 29, 2004 at 2:25 pm
Hi,
I was just trying to attempt the old QODs and I came across the following in the Security category. This one was QOD for 7/2/2003.
The question is How would you turn on C2-Level auditing?
The answer given by SQLServerCentral is that turn on the advanced options and set the value of 1 for 'c2 audit mode'.
But according to BOL, since this is an advanced option, SQL Server service needs to be stopped and started.
Can anyone confirm which is the correct one? i.e. does it need a restart or not?
Thanks
-KG
October 4, 2004 at 8:00 am
This was removed by the editor as SPAM
October 4, 2004 at 11:18 am
I believe you are correct in that SQL needs to restart.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 4, 2004 at 12:12 pm
Hi Steve,
Thanks for your reply.
-KG
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply