SQL Profiler TextData 一次过滤掉某几个字段,该怎么处理

SQL Profiler TextData 一次过滤掉某几个字段
在设置TextData字段时怎么可以一次性设置过滤几个字
比如同时过滤 FROM tSM 和 sp_reset_connection 两个字段

RPC:Completed exec sp_reset_connection 57
SQL:BatchCompleted SELECT * FROM tSM 57 7
SQL:BatchCompleted SELECT * FROM tSM 57 7
RPC:Completed exec sp_reset_connection 57
SQL:BatchCompleted SELECT * FROM tSM 57 7
SQL:BatchCompleted SELECT * FROM tSM 57 7
RPC:Completed exec sp_reset_connection 57
SQL:BatchCompleted SELECT * FROM tSM 57 7
SQL:BatchCompleted SELECT * FROM tSM 57 7
RPC:Completed exec sp_reset_connection 57
SQL:BatchCompleted SELECT * FROM tSM        57 7
SQL:BatchCompleted SELECT * FROM tSM 57 7

profiler sql


------解决方案--------------------
设置完你图中那个,然后按回车可以换行,再输入%FROM tSM%即可

posted @ 2020-06-11 11:19  木古白水  阅读(314)  评论(0编辑  收藏  举报