SQL trace

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SQL trace

SQL trace

Rate Topic

Display Mode

Topic Options

Author

Message

santhu

Posted Tuesday, April 15, 2008 6:37 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, September 28, 2010 9:24 AM
Points: 324, Visits: 143

Hi all,
i have a trace huge trace file, now i want to save it in a table but it gives the following error
" Multiple step OLEDB generated Error. Check OLEDB status if available.

Any help in this regard will be helpful

Post #484943

Kevin-458339

Posted Tuesday, April 15, 2008 6:59 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, April 12, 2012 1:59 AM
Points: 334, Visits: 3,135

Hi

On the trace file - you can change the proprties, i.e. change the selection of what events are shown, you may want to filter out the transactions and import section by section.

So if you have Security, Stored Procs and TSQL sections - deselect everything and only select TSQL and save that into a table and do each section until you either find the section that contains the error or each section gets saved to a table.

Let us know how it goes

Thanks
Kevin

Post #484967

santhu

Posted Wednesday, April 16, 2008 4:43 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, September 28, 2010 9:24 AM
Points: 324, Visits: 143

Thanks Kevin,

I did try it... and only after i removed storedprocedure it started working.
I also used the following script
"SELECT IDENTITY(INT,1,1) AS ROWNUMBER,*
INTO dbo.MyTraceTable
FROM ::fn_trace_gettable('C:\SqlTraces\MyTrace.trc', DEFAULT)"
even here it gives some error message as
'Unexpected end of tracefile." now how to track which entry has problem.

thanks

Post #485538

grahamc

Posted Thursday, January 14, 2010 4:23 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 3:21 AM
Points: 563, Visits: 943

generally that error means that your trace file is still being used/added to. You need to close the trace file then run the INTO table statement.

Post #847444

« Prev Topic | Next Topic »

Permissions