------------------------------------------------------------------
--                                                              --
--  File:   SQL_Server_Configuration.SQL                        --
--          Microsoft TPC-E Benchmark Kit Ver. 1.12.0-1022      --
--          Copyright Microsoft  2008, 2009, 2010               --
--                                                              --
------------------------------------------------------------------
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
