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 |
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2007-09-27 : 15:25:33
|
Hi,We have a query: delete from myTable *******and we get the error:Msg 8624, Level 16, State 1, Line 1Internal SQL Server error.When we run the same condition but with select instead of delete, every thing works fine, we only have pb with delete.How can we detect what the problem is. Because with Internal error Msg 8624 does not tell us any thing, what re we supposed to make the query works especially that it runs correctly in select mode.Thanks a lot. |
|
Kristen
Test
22859 Posts |
Posted - 2007-09-27 : 15:30:09
|
Hmmm ...All service packs up to date?I recommend doing DBCC CHECKDB to check if there is some corruption to the DB first.If that's OK then perhaps you are hitting some known bug.Perhaps turn parallelism OFF for the query.Maybe try:SET ROWCOUNT 10000delete from myTable *******SET ROWCOUNT 0and looping until you get ZERO ROWS. You might be hitting some limit on the number of rows deleted (but, in fairness, if you are just trying to delete a few rows that shouldn't be a problem)Kristen |
|
|
|
|
|