Sql Server 2000 Profiler Failed To Read Trace Data

File may be corrupt or it may have a wrong data format". Let me explain in a bit more detail: when a trace file is rolled over, at the end of it (the last row of it) there is a pointer (or a Once the trace is saved in a table, we can query it from SQL Server Management Studio (picture below). Install/Re-install MSXML and run "regsvr32 msxml6.dll" in command prompt: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=993c0bcf-3bcf-4009-be21-27e85e1857b1&DisplayLang=en Microsoft Core XML Services (MSXML) 6.0 -this is also available in the Feature Pack for this version of SQL Server More have a peek here

I copied the Microsoft SQL Server TraceDefinition 10.50.1600.xml, also ProfilerSpecialEvents.XML.profiler already exists in the folder C:Program FilesMicrosoft SQL Server100ToolsProfilerTraceDefinitions. Note: Instead of changing the default collation of an instance of SQL Server, you can specify a default collation for each new database you create. Are you aComputer / IT professional?Join Tek-Tips Forums! AFAIK You need to use SQL Profiler 2008 or newer. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=165463

Thanks for sharing the results of your hard and very detailed work. RE: SQL Profile Trace keeps stopping JohnTcolo (MIS) 20 Aug 08 22:36 Try saving it as sql script and then view using query tool.Just a thought. How do I dehumanize a humanoid alien? View all my tips Related Resources More SQL Server DBA Tips...

Post #227922 bas.bruijninckxbas.bruijninckx Posted Friday, December 21, 2007 2:06 AM Forum Newbie Group: General Forum Members Last Login: Wednesday, February 4, 2009 1:30 AM Points: 1, Visits: 3 But then the Any thoughts on this. I have got Standard Edition SP4. –Pavel Nefyodov Feb 15 '11 at 16:25 You might try importing the trace into ClearTrace (scalesql.com/cleartrace) and then into 2008. –Chris B. Every time a file is grown or shrunk, SQL Server will halt and wait for the disk system to make the file available again.

How do I create armor for a physically weak species? Word that means "to fill the air with a bad smell"? Column-level encryption can be a very effective way of doing this. Choose the trace file and click the Open button on the dialog box.

Why and how is this useful? navigate here However, when I check the database properties, both Auto Create Statistics and Auto Update Statistics are True. In case mentioned above, "Microsoft SQL Server TraceDefinition 9.0.1187.xml" was present in the TraceDefinitions directory so we would need to continue with remaining steps. -on 64-bit systems C:\Program Files (x86)\Microsoft SQL Anonymous Great article Thank you for sharing!

Figure 1: This is how the Default trace looks like So, how can we benefit from each audited category?

Centering equations under align more common way to say "act upon word or a promise" Detect the missing number in a randomly-sorted array Why does Harry address the Weasley-parents with "Mr. Thanks in advance. The following query will give you only the server start event: 12345678910111213141516171819 SELECT TE.name AS [EventName] , v.subclass_name , T.DatabaseName , t.DatabaseID , t.NTDomainName , t.ApplicationName , t.LoginName , t.SPID , Profiler loads the contents of the trace file as shown in the image below.

The default trace, introduced in SQL Server 2005, has the great advantage of being switched on by default, and is usually already there to use. I did it unknowingly. To find the exact file location of the default trace files, you just need to execute the following query: 123 SELECT REVERSE(SUBSTRING(REVERSE(path), CHARINDEX('\', REVERSE(path)), 256)) AS DefaultTraceLocationFROM sys.tracesWHERE is_default = 1 It is important to remember that the queries presented in this article will return the result from the single most recent default trace file.

Conclusion The default trace is a very powerful way to examine the health and the security of your SQL Server instance. Jayganesh Sambath SQL Query Performance Hi Feodor, Thanks for the article. What does this bus signal representation mean A World Where Everyone Forgets About You Why study finite-dimensional vector spaces in the abstract if they are all isomorphic to R^n?