Help with Fixing FIX: Access Violation Occurs When You Use SQL Profiler or SQL Trace Error

Summary: A handled access violation (AV) and/or the following error message may occur when you use SQL Server Profiler or SQL Trace:Failed to read trace dataThe AV only occurs if all of the following conditions are true:

You select a TextData column as a data column in SQL Trace.

Text data is sent from a non-Unicode client such as Isql.exe.

The text data contains double-byte character set (DBCS) characters.

Here is the short stack trace for the AV:Short Stack Dump004D8C1C Module(sqlservr+000D8C1C) (CShortConstLockBytesSS::ReadAt(union _ULARGE_INTEGER,void *,unsigned long,unsigned long *)+0000002B)006550EA Module(sqlservr+002550EA) (CLockBytesToLBSS::ReadAt(union _ULARGE_INTEGER,void *,unsigned long,unsigned long *)+00000035)006E2C2C Module(sqlservr+002E2C2C) (TSendRowClass<3,0>::TSendLOB(struct srv_proc *,class CTypeInfo const *,class CXVariant *)+0000026E)006E087C Module(sqlservr+002E087C) (CValOdsRow::SetDataX(unsigned long *,class CXVariant *)+00000221)00426566 Module(sqlservr+00026566) (SetDataWithPop(class CEsExec *,class CXVariant *)+0000001C)00416524 Module(sqlservr+00016524) (CEs::GeneralEval4(unsigned long *,class CEsExec *,class CXVariant *)+0000003D)004270DA Module(sqlservr+000270DA) (CStmtQuery::ErsqExecuteQuery(class CMsqlExecContext *,class CEsComp const *,class CEsComp const *,unsigned long *,int,int)const +00000451)00441A34 Module(sqlservr+00041A34) (CStmtSelect::XretExecute(class CMsqlExecContext *)const +0000021C)004160DB Module(sqlservr+000160DB) (CMsqlExecContext::ExecuteStmts(class ExecutionContext *)+0000027E)00415765 Module(sqlservr+00015765) (CMsqlExecContext::Execute(class CCompPlan *,class CParamExchange *)+000001C7)00415410 Module(sqlservr+00015410) (CSQLSource::Execute(class CParamExchange *)+00000343)0049CD0A Module(sqlservr+0009CD0A) (CStmtExec::XretLocalExec(class CMsqlExecContext *,unsigned short *,int,class WParseName *)const +00000154)0049CB9F Module(sqlservr+0009CB9F) (CStmtExec::XretExecute(class CMsqlExecContext *)const +00000322)004160DB Module(sqlservr+000160DB) (CMsqlExecContext::ExecuteStmts(class ExecutionContext *)+0000027E)00415765 Module(sqlservr+00015765) (CMsqlExecContext::Execute(class CCompPlan *,class CParamExchange *)+000001C7)00415410 Module(sqlservr+00015410) (CSQLSource::Execute(class CParamExchange *)+00000343)00459A54 Module(sqlservr+00059A54) (language_exec(struct srv_proc *)+000003C8)004175D8 Module(sqlservr+000175D8) (process_commands(struct srv_proc *)+000000E0)410735D0 Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue *)+00000264)4107382C Module(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)7800BEA1 Module(MSVCRT+0000BEA1) (_beginthread+000000CE)77E637CD Module(KERNEL32+000037CD) (TlsSetValue+000000F0)

If the trace is written to a file, SQL Server Profiler reports the following error message when you attempt to open the trace file:Failed to read file data. File may be corrupt. Or it may have a wrong data format.If the TextData column is not included, no errors occur.

Solution: Repairing FIX: Access Violation Occurs When You Use SQL Profiler or SQL Trace problem can not be that easy. To solve FIX: Access Violation Occurs When You Use SQL Profiler or SQL Trace problems effectively and efficiently, install a good FIX: Access Violation Occurs When You Use SQL Profiler or SQL Trace Error Removal Tool is a smart solution. This is an advanced optimizing tool the can repair all those problems that are slowing your computer down.

Install FIX: Access Violation Occurs When You Use SQL Profiler or SQL Trace Error Fixer Now

In order to repair FIX: Access Violation Occurs When You Use SQL Profiler or SQL Trace error, install SmartPCFixer immediately. This optimization tool is already proven to locate, identify, and fix FIX: Access Violation Occurs When You Use SQL Profiler or SQL Trace errors. Speed up your PC with SmartPCFixer at once

Manual Solutions

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in theMicrosoft Knowledge Base:290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

What Else Does SmartPCFixer Offer You?

Apart from fixing FIX: Access Violation Occurs When You Use SQL Profiler or SQL Trace problems, SmartPCFixer is designed to provide the user's computer system with better optimization, which helps you manage startup items, desktop, browser objects, Internet, system service, Windows optimization, file extensions and so on. With these sophisticated utilities your system is tuned up to run at the optimal state.

SmartPCFixer is designed to scan, diagnose and repair your operating system. Using it results in better optimization, manages startup and desktop, assists you with maintaining browser objects, internet options, system service, and repairs file extensions. With this arsenal of powerful, sophisticated utilities your system is tuned to run at its optimal state. Included are Easy Repair Wizard, Error Utilities, File Association fixer, Register ActiveX, Shortcuts Fixer, Winsock2 Repair toolkit, Dll Fixer and more.

Related: Error 50 Itunes,Too Many Redirects,Temporary Error 18,Error 12007,Error 303
Read More: ,BUG: Control Repaint Problems When ClipControls Set to False,BUG: Help System Closes After Closing Printer Properties Window,COM1 and COM2: Communications Device Default Buffer Size,A GUID appears instead of the product name in the Competitor List by Product report in Microsoft CRM,16-bit OLE Files Are Not Replaced by Office 95 Setup