Prev: T-SQL - How to use xp_regread to get ALL time zone information
Next: Who Created a Table
From: Waldy on 14 Oct 2008 05:48
How can I delete some rows from a database when I get the above error?

It is a simple delete from table where column = value type statement.


From: Waldy on 14 Oct 2008 07:12
"dave ballantyne" <symlink(a)nospammeever.yahoo.com> wrote in message
news:e35kTMeLJHA.4996(a)TK2MSFTNGP03.phx.gbl...
> Seems like a fix here, http://support.microsoft.com/default.aspx/kb/945896

I just installed that, but it made no difference.


From: Waldy on 14 Oct 2008 09:03
"dave ballantyne" <symlink(a)nospammeever.yahoo.com> wrote in message
news:u$j6$LfLJHA.5660(a)TK2MSFTNGP03.phx.gbl...
> In that case, please post the query and DDL

Hi Dave,
it's not a query. It's just a simple delete statement

delete from table where column = value

There are about a dozen foreign keys and the same number of constraints on
the table. I can only guess that it's something to do with that.


From: Waldy on 14 Oct 2008 10:50
Is there any way to turn off query optimization?


From: Gert-Jan Strik on 14 Oct 2008 18:07
Waldy wrote:
>
> How can I delete some rows from a database when I get the above error?
>
> It is a simple delete from table where column = value type statement.

Have you checked that "table" is actually a table and not a view?

Do you get a query plan (and not an error) if you change "delete" to
"SELECT *"?

--
Gert-Jan
SQL Server MVP
 | 
Pages: 1
Prev: T-SQL - How to use xp_regread to get ALL time zone information
Next: Who Created a Table