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 |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2006-04-11 : 00:34:38
|
| Hi there,I have a sql server 2000 sp3 on a windows 2003 box. The box keeps crashing due to several .net applications which run a query similar to the below:* SELECT * FROM OPENQUERY([MYDATABASESERVER],'set fmtonly off;exec MyDatabaseName* .dbo.p_MyStoredProcedure "1842"') WHERE ID = 3046This query generates the error below and I was hoping someone has seen an example of OPENQUERY crashing sql processes before?SqlDumpExceptionHandler: Process 153 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..* ********************************************************************************* BEGIN STACK DUMP:* 04/11/06 07:39:21 spid 153** Exception Address = 7C82FC10 (RtlAllocateHeap + 00000213 Line 0+00000000)* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION* Access Violation occurred reading address FFFFFFF8 |
|
|
matt_calhoon
Posting Yak Master
235 Posts |
Posted - 2006-04-12 : 03:52:54
|
| More on this so hopefully someone can help!the stored proc is:CREATE procedure dbo.p_MyStoredProcedure @ContentVersionID intas SELECT cast(tbl_File.FileID as Integer) as [ID],tbl_File.* FROM tbl_ContentVersion_File INNER JOIN tbl_File on tbl_ContentVersion_File.FileID = tbl_File.FileID WHERE ContentVersionID = @ContentVersionID GO |
 |
|
|
|
|
|
OpenQuery crashes sql server