Cannot delete rows using [image] IS NULL - by GrantaGuy

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


6
0
Sign in
to vote
ID 321074 Comments
Status Closed Workarounds
Type Bug Repros 2
Opened 1/4/2008 8:40:05 AM
Access Restriction Public

Description

Deleting rows from a table does not work as expected.

The table contains an image column for which I want to delete all rows that have a NULL value for this column. This works fine until I have a foreign key referencing the table, at which point any rows that have had their image column UPDATED to be NULL fail to be deleted.

This problem occurs on at least SQL 2005 Express Edition and SQL 2005 Developer Edition.
Sign in to post a comment.
Posted by Microsoft on 8/11/2008 at 9:15 AM
The issue is fixed in SQL Server 2008. It will also be fixed in the next SQL Server 2005 service pack. Thanks for helping us identify this! -Eric
Posted by Microsoft on 1/31/2008 at 6:43 PM
Thanks for raising the issue.

We've managed to reproduce the problem and will look for resolutions now.