Question about this error Procedure expects parameter '@traceid' of type 'int'

• D-SQL

  SSCrazy

  Points: 2265

  More actions

  February 26, 2014 at 11:12 am

  #304523

  I'am running this and getting an error. Help appreciated

  DECLARE @trace_ID int , @path_file nvarchar(200)

  --SELECT @path_file=output_path_file FROM table WHERE tid = 1

  --SELECT @trace_ID = traceid

  --FROM ::fn_trace_getinfo(0)

  --WHERE property = 2

  --AND value = @path_file

  EXEC sp_trace_setstatus @trace_ID,0--<< stop ---- I believe the error is here

  EXEC sp_trace_setstatus @trace_ID,2--<< Close

  Msg 214, Level 16, State 5, Procedure sp_trace_setstatus, Line 1

  Procedure expects parameter '@traceid' of type 'int'

  I tried this also

  EXEC sp_trace_setstatus '@trace_ID + CAST(varchar,id) + ', 0

  EXEC sp_trace_setstatus '@trace_ID + CAST(varchar,id) + ', 2

  Thanks in advance

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  February 26, 2014 at 11:33 am

  #1692384

  Try this ..

  declare @trace_id INT

  select @trace_id = 0

  select @trace_id = traceid

  from ::fn_trace_getinfo (NULL)

  -- where value = 'D:\Server_TraceFiles\trace\profiler.trc' (Modify This )

  EXEC master..sp_trace_setstatus @traceid = @trace_id ,@status = 0

  -- Closes the specified trace and deletes its definition from the server.

  EXEC master..sp_trace_setstatus @traceid = @trace_id ,@status = 2

  --

  SQLBuddy