admin_trace_stopall Truncation issue

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.

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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources