Error importing data

Sep 28, 2008 at 1:33 PM
I have a problem inporting data using readtrace. The import fails when it tries to create a unique clustered index on the seq key for table tbluniquestatements, it fails with a duplicate key error. When I check the table it does have multiple duplicate seq keys.

Any help welcome.

Ronnie
Coordinator
Oct 3, 2008 at 9:02 PM
based on the conversation among ourselves, we have answered your question.
for the purpose of other people, here is the detail
If you use profiler (instead of sqldiag and our canned batch file to capture), a event can be lost.  it will result in such behavior.
future version will stop importing to avoid confusion if readtrace detects a event is lost.
so best pratice is to use our canned batch file with trace defintion together with sqldiag (home page of this tool has link )  to collect server side tracing.