Query with union no longer updatable in SQL 2005

I have a query that uses a union that was updatable in SQL 2000 but not SQL
2005
Here is a simple example of a result set that is updatable in SQL 2000 but
not SQL 2005
Northwind DB
SELECT CustomerID, CompanyName, ContactName
FROM Customers
WHERE (CustomerID = 'ALFKI')
UNION ALL
SELECT CustomerID, CompanyName, ContactName
FROM Customers
WHERE (CustomerID = 'ANATR')Richard
Can you show us your UPDATE statement?
"Richard Brown" <RichardBrown@.discussions.microsoft.com> wrote in message
news:C5D146D9-CA8E-4984-8417-08BEFCFE3816@.microsoft.com...
>I have a query that uses a union that was updatable in SQL 2000 but not SQL
> 2005
> Here is a simple example of a result set that is updatable in SQL 2000 but
> not SQL 2005
> Northwind DB
> SELECT CustomerID, CompanyName, ContactName
> FROM Customers
> WHERE (CustomerID = 'ALFKI')
>
> UNION ALL
> SELECT CustomerID, CompanyName, ContactName
> FROM Customers
> WHERE (CustomerID = 'ANATR')|||The problem was discussed in MSDN Product Feedback Center in the
following bug report (which was closed with the resolution "by
design"):
http://lab.msdn.microsoft.com/produ...59-17b0073cfa26
Razvan