This is just a guess of a solution that might resolve your problem. As Frank said, if it doesn't work, post some data along with the table definition and...

Compagny... never been much of a freelancer.

Two things come to mind :

1 - Is there a trigger that can rollback the transaction without throwing an error?

2 - Is it possible that the application is using...

I know... but it's to make sure everybody else can find the rest of the thread . Also makes sure that we don't...

Yes you can, but the real expression is : "To cut a long story, short ...."

Thanx.

Hey looks like I'm finally passing you for the post count .

Gonna reread it... looks like I missed that part .

Maybe you can ask the developpement team if a blob column has been dropped lately. That would be your best bet to get that info, unless you have a...

This is just an assumption from what I know of sql server's inner workings. It would be nice if someone else could confirm my deductions...

Anyone??

... And what does CE stands for?

Can't help you there, sorry. I've never sued used CE and this error message doesn't help me at all understand the problem.

Have you tried breaking the query apart...

Internally, the indexes and stats are linked to the id of the object. If you change the name of the object, only its name is changed. So I would...

What's the error message??

Can't see any error in that query...

Hence the term MVP used to qualify Frank .

Given that you have tried everything else in mind, and that you have no other idea, then I'd go for it unless it can cause problems for the users.