Posted by michael via SQLMonster.com on 03/01/06 16:52

Okay, looks like I've got it working now. I needed to use CAST instead of
CONVERT for the traceid to get it to read as an INT.

Thanks again for the feedback.

michael wrote:
>Thanks for your response. I think I might not have stated the issue clearly
>or am not understanding your response. My issue is that the traceid is not
>being returned as an INT. There is no problem with the file name and the
>nvarchar.
>
>Of the PRINT statements in my code below, I get everything up to and
>including 'Stop current trace'. My SET does return the traceid, but not in
>integer format.
>
>I'll do further research on the sql_variant though and see if I can get
>further with that.
>
>Thanks
>
>>> I am trying to automate a SQL Trace via a stored procedure and a job.
>>> The job executes the stored procedure to start the trace and every 15
>[quoted text clipped - 19 lines]
>>I would recommand to explicitly convert value to nvarchar(4000).
>>is sql_variaamt

--
Message posted via http://www.sqlmonster.com

[Back to original message]