C2 audit mode

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???

Which edition of sql2k5 do you have?

Microsoft SQL Server 2005
Standard Edition SP3

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

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