stupid stupid sql server-- what should I do?# Database - 数据库
m*y
1 楼
I'm writing some store procedures to build trace and set status etc. and I
have a problem here.
For example, I want to set some filter that only captures the duration
greater than 5000 but the code
EXECUTE sp_trace_setfilter
@traceid=1,
@columnid=13,
@logical_operator=0,
@comparison_operator= 4,
@value=5000
doesn't work because the last parameter is expecting a bigint!!!
If I define a bigint parameter first like the below and it will work:
declare @abc bigint
set @abc=5000
EX
have a problem here.
For example, I want to set some filter that only captures the duration
greater than 5000 but the code
EXECUTE sp_trace_setfilter
@traceid=1,
@columnid=13,
@logical_operator=0,
@comparison_operator= 4,
@value=5000
doesn't work because the last parameter is expecting a bigint!!!
If I define a bigint parameter first like the below and it will work:
declare @abc bigint
set @abc=5000
EX