The smaller the column, the better. The real question is how many records do you expect to have? If you think you'll go well over 3 billion (int...

If you hit : edit post, then you can delete the duplicate post.

I remember that thread. It wasn't exactly the same problem. The guy wanted to TRANSFER the data to an audit table. So he had to do an...

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...