none
Bulkcopy RRS feed

  • Question

  • i need to import the data from .trc(trace file).W are useing following syntax.

    select  'TraceFile.trc'
        from dbo.Test
        where and ServerName = @ServerName

    insert into dbo.TraceInfo(txtData,
    TextData,
    BinaryData,
    DatabaseID,
    TransactionID,
    ServerName ,
    LineNumber )

    but it takes too much time to import the data. any othere better  method is there to save the time?

    Thanks.
    Best Regards,
    Sathiya.


    Thursday, March 20, 2008 1:50 PM

Answers

All replies