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

sp_configure - reconfigure Expand / Collapse
Author
Message
Posted Thursday, November 05, 2009 9:40 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 12, 2010 10:47 AM
Points: 24, Visits: 58
I have a quick question. Can you run the following on a production live database while users are on it?

sp_configure 'show advanced options'1
go
reconfgure
go

Thank You
Post #814375
Posted Thursday, November 05, 2009 9:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 5:39 AM
Points: 2,104, Visits: 5,378
Yes you can, but notice that you are missing a coma in your statement.

Adi


--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #814377
Posted Thursday, November 05, 2009 9:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 12, 2010 10:47 AM
Points: 24, Visits: 58
Thank You
Post #814382
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse