Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2002-09-06 : 14:34:48
|
| Hello, I got the below mentioned error when one of my users tried cross-database query. Is the query bad or OLE is messed?Would this affect any of my other scheduled backup processes?What does access voilation mean?Error:SqlDumpExceptionHandler: Process 68 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..* BEGIN STACK DUMP:* 09/06/02 11:17:27 spid 68** Exception Address = 055E7B3E* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION* Access Violation occurred reading address 00000000* Input Buffer 114 bytes -* SELECT COUNT(*) FROM DTCPSDEV.HRDEV.dbo.PS_TX_CLIENT_ID _____________________________________________________________________**Thanks,Sarat |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-06 : 14:45:30
|
| What SQL Version and service pack and what Operating System and Service Pack(on both servers). Are you using the SQLOLEDB driver ?Access Violations are bus, its probably been fixed but more information is required from you. You can also have a look at the Microsoft Knowledge Base to see if you can find the solution yourselfHTHJasper Smith |
 |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2002-09-06 : 15:13:47
|
| Hey!I figured out the problem. I panicked because this happened on Prod box. Anyway, the reason is that the Linked Server was setup incorrectly. It was using 'Other Source' instead of SQL Server for OLE DB Jet. When I recreated my linked server by using SQL Server, the query worked fine. The scheduled backup is also running fine!Thanks,Sarat |
|
|
|
|
|
|
SQL Dump Error due to a T-SQL