SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 ClearTrace Support Forum
 admin_trace_stopall Truncation issue
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

DrRandy
Starting Member

3 Posts

Posted - 08/17/2011 :  19:50:42  Show Profile  Reply with Quote
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

USA
4137 Posts

Posted - 08/18/2011 :  08:26:34  Show Profile  Visit graz's Homepage  Reply with Quote
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

USA
4137 Posts

Posted - 08/18/2011 :  08:32:31  Show Profile  Visit graz's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000