Delete join with a view generates an Internal SQL Server error

Last Post 08 Dec 2008 08:58 AM by TAMartin. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
pattymelt
New Member
New Member

--
07 Jul 2008 06:49 AM
We have some stored procedures that delete records based on the results from a view. These procedures have worked for years but now they generate the following message:
Msg 8624, Level 16, State 1, Line 1
Internal SQL Server Error.

The general format of the Delete statement is:

DELETE tableData FROM tablename tableData JOIN DeleteSelectView viewData
on (tableData.keyfield = viewData.keyfield)

Does anyone have any suggestions as to why these type of Delete statements have just started generated the Internal SQL Server error?
pattymelt
New Member
New Member

--
08 Jul 2008 06:44 AM
The information regarding Trace Flags in the following article was used to eliminate the Internal SQL Server error:
http://support.microsoft.com/kb/885442/en-us

We used the command DBCC TRACEON(9057, -1) to have our server revert to its prior behavior, and the Internal SQL Server error has disappeared.
TAMartin
New Member
New Member

--
08 Dec 2008 08:58 AM
Has this been resolved? We are seeing a similar issue with a stored proc (SQL2k, SP4) running for years. Yesterday, we received an sql internal error on it.
You are not authorized to post a reply.

Acceptable Use Policy