Internal SQL Server error.(42000,8624)

Question

Post reply

Internal SQL Server error.(42000,8624)

Steven Cripps

SSC Veteran

Points: 289
More actions
November 1, 2005 at 7:13 am

#91603

Pls forgive me I am new to this list serve:
I am getting the error, listed in the subject line, from a sp run through dts. The exact statement that I am getting this wonderful error from is:
delete TaxAddress
from TaxAddress,Parcel,CvtMadParcel
where TaxAddress.ParcelID = Parcel.ParcelID and
Parcel.UserDefinedID = CvtMadParcel.Parcel_no and
Parcel.TaxYear = 2004
If I run this deletion on its own from Artisan, I get the same error. This code has been running weekly for over a year. It just stopped working with SQL Server 2000 SP 3.
Any clue as to why it stopped working??
Thank you.

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247180 More actions · Answer 1

Don't know, but your query could be rewritten using joins:

delete ta

from TaxAddress ta join Parcel pa on ta.parcelid = pa.parcelid

join CvtMadParcel cmp on pa.userdefinedid = cmp.parcel_no

where pa.taxyear = 2004

Might be worth a try.

Steven Cripps SSC Veteran Points: 289 More actions · Answer 2

The error is more than likely a server, table or index issue. The sp ran fine until the latest service pack was loaded.

Jo Pattyn SSC-Dedicated Points: 32513 More actions · Answer 3

Reapply the service pack, perhaps the installation wasn't succesfull.

Steven Cripps SSC Veteran Points: 289 More actions · Answer 4

I can ask the server admin do that. Of course he will tell me that everything went fine and it is a waste of time.

Any idea where I might find messages telling me if there were problems installing the service pak?

Steven Cripps SSC Veteran Points: 289 More actions · Answer 5

FYI, joins did not work. I guess the only thing I can do is call Microsoft, yipee.

Phil Parkin SSC Guru Points: 247180 More actions · Answer 6

This is a weird one. Have you run dbcc checkdb?

Also, if you run the statement directly through QA (rather than as part of a stored proc), do you get the same message? If you do, can you post the exact message?

Steven Cripps SSC Veteran Points: 289 More actions · Answer 7

Yes, if I run the query through Artisan I get the message outside of the Stored Procedure. (I just ran it through Query Anal (QA?) to see if it might have been an Artisan issue.) I got the same message:

Server: Msg 8624, Level 16, State 1, Line 1

Internal SQL Server error.

Phil Parkin SSC Guru Points: 247180 More actions · Answer 8

Check this article & see whether it's relevant:

http://support.microsoft.com/kb/885442