<div>
I guess the customer will have to resort to post-processing the results.
</div>


I guess the customer will have to resort to post-processing the results.

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
My customer has a question and I don't have an environment to test this. But he is currently saving SQL traces to a SQL table. The problem is when the trace ends (for whatever reason, he says when the target server restarts the trace ends), then saving to that table ends. Which means that the next time he starts a trace and he wants to use the same table name, then it asks him if he wants to overwrite the table or cancel. If he clicks overwrite, then he loses all the trace data he collected before, if he clicks cancel, then he is unable to continue with the trace.<br />
<br />
How can he resume saving trace information to the same table?<br />
<br />
Thanks.<br />
Dave
</div>
</div>


Hi All,

My customer has a question and I don't have an environment to test this. But he is currently saving SQL traces to a SQL table. The problem is when the trace ends (for whatever reason, he says when the target server restarts the trace ends), then saving to that table ends. Which means that the next time he starts a trace and he wants to use the same table name, then it asks him if he wants to overwrite the table or cancel. If he clicks overwrite, then he loses all the trace data he collected before, if he clicks cancel, then he is unable to continue with the trace.

How can he resume saving trace information to the same table?

Thanks.
Dave

SQL Server 2005 Profiler save multiple traces to the same table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.