Posted by Alexander Kuznetsov on 09/20/06 17:51

> Apparently the target table is part of indexed view.

or it has an index on a computed column - same restrictions.

-----------------------
Alex Kuznetsov
http://sqlserver-tips.blogspot.com/
http://sqlserver-puzzles.blogspot.com/

• Next in forum: cursor to compare/report on the same fields in 2 tables
• Prev in forum: Re: DELETE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'
• Thread view: Re: DELETE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'

[Reply to this message]