C2 audit mode

[yogesphu]

I have a question regarding turning on the advanced option 'c2 audit mode'.
I am doing it as below:

sp_configure 'c2 audit mode',1
reconfigure

But in sys.configurations system view the 'value_in_use' is still shown as 0

Whereas if i try to do the same for some other advanced option say 'xp_cmdshell'

sp_configure 'xp_cmdshell',1
reconfigure

it shows 'value_in_use' as 1.

so i was just wondering whether 'c2 audit mode' option is ON or NOT on my server.

The account that i am using, to turn this option on, is the member of sysadmin server role.

could you help me with this???

[rmiao]

Which edition of sql2k5 do you have?

[yogesphu]

Microsoft SQL Server 2005
Standard Edition SP3

[rmiao]

Are you sysadmin? Didn't you restart sql after enabling it?

[yogesphu]

Thanks a lot mate!!!
i am sysadmin!!
but i didnt restart the SQL service!!
Now i reastarted the service!!!
it worked!!
thanks!!!