Results 1 to 6 of 6

Thread: Configuration options

  1. 08-03-2009, 01:49 AM #1
    yogesphu
    yogesphu is offline Registered User
    Join Date
    May 2009
    Posts
    41

    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!!!!
    Reply With Quote Reply With Quote
  2. 08-03-2009, 09:21 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Check with sp_configure.
    Reply With Quote Reply With Quote
  3. 08-04-2009, 01:17 AM #3
    yogesphu
    yogesphu is offline Registered User
    Join Date
    May 2009
    Posts
    41
    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??
    Reply With Quote Reply With Quote
  4. 08-04-2009, 07:22 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You can view them with sp_configure in all versions of sql server.
    Last edited by rmiao; 08-04-2009 at 02:42 PM.
    Reply With Quote Reply With Quote
  5. 08-04-2009, 08:20 AM #5
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    See run_value column of the output.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
  6. 08-05-2009, 06:38 AM #6
    yogesphu
    yogesphu is offline Registered User
    Join Date
    May 2009
    Posts
    41
    Got u guys!!!
    thanks a lot!!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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