May 12, 2009 at 5:42 pm
When I use fn_trace_gettable (on Win2003 x64, SQL 2000 Enterprise 32 bit with SP4), as in:
Select *
FROM ::fn_trace_gettable('E:\audittrace_20090306155510_33.trc',0)
I get data rows returned but also an error message "Server encountered an error".
If I attempt to put these rows into a table, as in:
Select *
into #temp
FROM ::fn_trace_gettable('E:\audittrace_20090306155510_33.trc',0)
I only get an error message and nothing into the table.
Any ideas?
Patrick.
May 13, 2009 at 3:04 am
Does it show any error in the logs?
-Roy
May 13, 2009 at 7:12 am
Can you open the trace file successfully in Profiler? What if you change the second parameter to 1?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 13, 2009 at 10:20 am
No Errors in Logs...and these are C2 Audit Trace logs. But I do know the server was rebooted around this time.
May 13, 2009 at 10:28 am
Good Questions:
I can open the trace file sucessfully in profiler. I can also query the trace file successfully (with error message at the end).
I also tried using Parms, 0, 1, and default. All give the same results.
I'm trying to insert the trace data into a table using fn_trace_gettable. But no luck.
May 14, 2009 at 6:14 am
paste the compl;ete error message. there has to be an error number associated with this error
May 14, 2009 at 9:21 am
Complete error message:
Msg 568, Level 16, State 10, Line 8
Server encountered an error 'E:\Program Files\Microsoft SQL Server\MSSQL\Data\audittrace_20090306155510_33.trc'.
May 14, 2009 at 4:31 pm
May 14, 2009 at 4:43 pm
You are Incredible!!! We are testing the patch tonight.
Thanks,
Patrick.
May 14, 2009 at 5:06 pm
let us know the outcome by tomorrow and please pay attention to the more info section
To enable this hotfix, you must turn on a 1903 trace flag.
After you apply this hotfix, you can successfully import trace files into tables. However, you will continue to receive the error message
May 14, 2009 at 9:36 pm
Installed and Works!!!
A few notes. Build 2175 as advertised in:
http://support.microsoft.com/kb/911678
Does NOT work anymore. You need Build 8.00.2273.
Again this is only for SQL 2000 system that are running 32 bit on Win2003 64 bit and are trying to use fn_trace_gettable to load data into a table.
Thanks everyone who contributed.
Patrick.
Vice President
San Diego SQL Server Users Group
May 14, 2009 at 9:51 pm
Installed and works!
A few notes:
The build idenitified in http://support.microsoft.com/kb/911678
does NOT fix this. You need build 2273.
You also (as previously stated) need Trace Flag 1903 turned on.
This only effects machines running on Win2004 64 bit using SQL 2000 32 bit.
Thanks to all who contributed.
Patrick.
Vice President
San Diego SQL Server Users Group
May 15, 2009 at 5:13 pm
Installed and works!
A few notes:
The build idenitified in http://support.microsoft.com/kb/911678
does NOT fix this. You need build 2273.
You also (as previously stated) need Trace Flag 1903 turned on.
This only effects machines running on Win2004 64 bit using SQL 2000 32 bit.
Thanks to all who contributed.
Patrick.
Vice President
San Diego SQL Server Users Group
May 15, 2009 at 5:14 pm
Installed and works!
A few notes:
The build idenitified in http://support.microsoft.com/kb/911678
does NOT fix this. You need build 2273.
You also (as previously stated) need Trace Flag 1903 turned on.
This only effects machines running on Win2004 64 bit using SQL 2000 32 bit.
Thanks to all who contributed.
Patrick.
Vice President
San Diego SQL Server Users Group
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply