Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What transactions system "Configuration option 'show advanced options' changed from 0 to 1" execute ? Expand / Collapse
Author
Message
Posted Tuesday, November 27, 2012 10:54 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, January 14, 2013 12:01 AM
Points: 24, Visits: 104
Dear Admin,
Why belowlog appears in MSSQL log. What transactions system execute ?

MSQSQL 2008 R2

Date 11/28/2012 11:57:32 AM
Log SQL Server (Archive #1 - 11/28/2012 11:57:00 AM)

Source spid56

Message
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

Post #1389510
Posted Tuesday, November 27, 2012 11:51 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:17 AM
Points: 1,379, Visits: 2,687
nhphuong76 (11/27/2012)
Dear Admin,
Why belowlog appears in MSSQL log. What transactions system execute ?

MSQSQL 2008 R2

Date 11/28/2012 11:57:32 AM
Log SQL Server (Archive #1 - 11/28/2012 11:57:00 AM)

Source spid56

Message
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.



sp_configure 'show advanced options' ,0 

This is used to make changes to the Instance Configuration

http://msdn.microsoft.com/en-us/library/ms188787.aspx
Post #1389522
Posted Wednesday, November 28, 2012 12:33 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, January 14, 2013 12:01 AM
Points: 24, Visits: 104
I want to know what the transactions executed ?
Post #1389540
Posted Wednesday, November 28, 2012 12:36 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:17 AM
Points: 1,379, Visits: 2,687
nhphuong76 (11/28/2012)
I want to know what the transactions executed ?


Do you want to know which configuration setting was changed?

Are there any other similar messages in the error log?

Post #1389545
Posted Wednesday, November 28, 2012 1:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:23 AM
Points: 6,365, Visits: 13,693
nhphuong76 (11/28/2012)
I want to know what the transactions executed ?

You'll commonly see this in the log if an admin opens the SQL Server instance properties page (right click the instance in SSMS object explorer then click Properties)


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1389567
Posted Wednesday, November 28, 2012 6:46 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, January 14, 2013 12:01 AM
Points: 24, Visits: 104
SQL log

Date 11/28/2012 11:57:32 AM
Log SQL Server (Archive #1 - 11/28/2012 11:57:00 AM)

Source spid56

Message
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
Post #1390225
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse