
复制/*+---------------------------------------------------------------------------------------------------------------------------------------            *    名称:        [DBO].[Performance_Trace_StopAll]             *    功能:        防止反跟踪             *    作者:        junling             *    创建时间:    2011-02-09             *    项目名称:    XXXX             * -----------------------------------------------------------------------------------------------------------------------------------------            *    历史记录             *    编号    日期        作者    备注             *    1.0    2011-02-09    junling    创建             ------------------------------------------------------------------------------------------------------------------------------------------+*/            create  proc [dbo].[Performance_Trace_StopAll]             AS                declare traceCursor cursorforselect id from sys.traces where id <> 1                 open traceCursor                 declare @curid int                fetchnextfrom traceCursor into @curid                 while(@@fetch_status=0)                   begin                      exec  sp_trace_setstatus @curid,擦亮0                       exec  sp_trace_setstatus @curid,2                       fetchnextfrom traceCursor into @curid                   end                close traceCursor                 deallocate traceCursor             1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.