http://www.sqlmag.com/authors/author/author/5044261/rsscomment/5044261en-USFri, 25 May 2012 10:32:03 GMTFri, 25 May 2012 10:32:03 GMThttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorThu, 17 Aug 2006 10:48:30 GMT
Great work Steven Berringer. Excellent. Thanks. Naras]]>NARASIMHANThu, 17 Aug 2006 10:48:30 GMThttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorhttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorFri, 28 Oct 2005 11:22:44 GMT
Very good article... I plan to adapt this to write to database another server using linked server functionality. David]]>dgoodale@casestack.comFri, 28 Oct 2005 11:22:44 GMThttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorhttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorTue, 05 Jul 2005 13:19:47 GMT
The sp referred to in the article - sp_create_trace is actually called sp_trace_create. ]]>DELTue, 05 Jul 2005 13:19:47 GMThttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorhttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorTue, 10 May 2005 15:43:48 GMT
Excellent article and code. What a great ideal to build the trace as you want in Profiler then save to a SQL script and transform into a stored proc for batch Profiler data collection. Well done Steven]]>flexdba Tue, 10 May 2005 15:43:48 GMThttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorhttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorWed, 27 Oct 2004 06:26:56 GMT
good article - a few code errors but nothing that can’t be easily fixed. I used it as good starting point for customizing for a multi-server environment for auditing after our Sarbanes-Oxley audit - yuk! ]]>PAIGEWed, 27 Oct 2004 06:26:56 GMThttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorhttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorWed, 13 Oct 2004 07:51:57 GMT
Very useful indeed.]]>PeterWed, 13 Oct 2004 07:51:57 GMThttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorhttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorTue, 31 Aug 2004 08:07:48 GMT
Very Good article and was very helpful Venu]]>avula_venu Tue, 31 Aug 2004 08:07:48 GMThttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorhttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorMon, 02 Aug 2004 07:39:09 GMT
I only found the 1 bug. I had to modify the code for Step2 of the StopTrace job from: SELECT @trace_ID = traceid FROM ::fn_trace_getinfo(0) WHERE property = 2 AND value = @path_file to SELECT @trace_ID = traceid FROM ::fn_trace_getinfo(0) WHERE property = 2 AND convert(varchar(104),value) = @path_file otherwise the match on @path_file always returned 0 rows. Otherwise, very useful article which taight me some nice tricks with handling Profiler traces that I didn’t know about.]]>pyaleMon, 02 Aug 2004 07:39:09 GMThttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorhttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorThu, 29 Jul 2004 12:03:05 GMT
Good article but the code is full of bugs]]>bstevenson Thu, 29 Jul 2004 12:03:05 GMThttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorhttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorMon, 26 Jul 2004 02:25:50 GMT
Good article. however, in most of the cases, tracing is done against the production server (it is part of making the DB perfect!), but the uploading (into a table) and anlyzing is done on another server (may be DBA’s personal server or dev server). This article didnt mention how the automation is designed in a multi server environment]]>preethiMon, 26 Jul 2004 02:25:50 GMThttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorhttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchorMon, 26 Jul 2004 01:21:16 GMT
This a good article ]]>DALJITMon, 26 Jul 2004 01:21:16 GMThttp://www.sqlmag.com/article/tsql3/9-steps-to-an-automated-trace#commentsAnchor