Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 ClearTrace Support Forum
 admin_trace_stopall Truncation issue

Author  Topic 

DrRandy
Starting Member

3 Posts

Posted - 2011-08-17 : 19:50:42
Hi. I tried to use admin_trace_stopall to stop a trace. It did not work with a long pathname.

SELECT DISTINCT TraceID
FROM :: fn_trace_getinfo(default)
where property = 2
AND CAST(value AS NVARCHAR) LIKE @BaseFile + '%'

should perhaps be

SELECT DISTINCT TraceID
FROM :: fn_trace_getinfo(default)
where property = 2
AND CAST(value AS NVARCHAR(max)) LIKE @BaseFile + '%'

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2011-08-18 : 08:26:34
DrRandy, I think you are right. Let me see about getting that fixed.

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2011-08-18 : 08:32:31
And that script is updated. I used NVARCHAR(2000). Hopefully there's still a chance it will work with SQL Server 2000.

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.
Go to Top of Page
   

- Advertisement -