-
Configuration options
Hi
Is there any system view in sql server 2000 conrresponding sys.configurations in SQL Server 2005
Actually i want to manipulate with some of the advanced options(like c2 audit mode and all). but how do i know their current status.
thanks!!!!
-
-
thanks 4 ur reply!!!
but
sp_configure will alow me to set the options
i want to view what are the current settings.
is there any way in sql server 2000??
-
You can view them with sp_configure in all versions of sql server.
Last edited by rmiao; 08-04-2009 at 02:42 PM.
-
See run_value column of the output.
-
Got u guys!!!
thanks a lot!!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|