----------------------------------------------------------------
--                                                              
--  File:   SQL_Server_Configuration.SQL                        
--          Microsoft TPC-E Benchmark Kit Ver. 1.14.0-1031      
--          Copyright Microsoft, 2008-2015                  
--                                                              
----------------------------------------------------------------
USE master
GO

-- set show advanced options to 1 so we get all the available options
sp_configure    'Show advanced options',1
GO

-- reconfigure the server so the show advanced option will take effect
reconfigure with override
GO

-- output the SQL Server Trace Flags
DBCC TraceStatus
GO

-- output the SQL Server configuration
sp_configure
GO
