Back to the main page
Can't find the answer? Ask
Submit Articles
Publish your articles and reach thousands of readers worldwide.
Publish
■ Welcome Guest, LogIn
■ Connexion avec 
Category : Computers & Internet » Programming » SQL | Posted by : Viper | Posted on : 1/20/2012 | Updated on : 1/20/2012
Keywords : query, following, database, server, processor, edition, unexpected, internal, sql, message, am, running, query, delete, encountered, error, xxx, express
Internal Query Processor Error: The query processor encountered an unexpected error during execution
I am running a query on a SQL Server 2008 database express edition and when a do a delete query
" delete from xxx where id='exemple' " i have the following error message :

"Internal Query Processor Error: The query processor encountered an unexpected error during execution."

then i tried ,to delete that row with sql managment studio 2008, i have this error message :

A problem occurred attempting to delete row 1
Error Source: .Net SqlClient Data Provider
Error Message: Internal Query Processor Error: The query processor encountered an unexpected error during execution.

Answers

Cannot delete that row.

is there any command to check or repare the sql2008 from errors ?

i've got the same error before with a large database after an brutal shutdown of the server, and i haven't found any solution, so i created another database and copied all the data to the new database.
You have an answer to this question?
Answer this question as a guest or ( Login / Create an account )
Full name : e-mail :  * will not be displayed
Retype the picture text
Send your Answer

Other languages : Verkus in English English, Verkus en Français Français. Terms of use | Privacy Policy | Help © Verkus 2008-2010, All rights reserved.