sp_configure "sql text pipe active",1 go sp_configure "statement pipe active",1 go sp_configure "statement statistics active",1 go sp_configure "max SQL text monitored",2000 /* will need to restart server for this one */ go sp_configure "SQL batch capture",1 go sp_configure "sql text pipe max messages",2000 go sp_configure "per object statistics active",1 go sp_configure "statement pipe max messages",2000 go sp_configure "per object statistics active",1 go sp_configure Monitor /* this command will display all the Monitor parameters */ go
