Hi,

Per SQL 2000 BOL, "A partitioned view will not be updatable if a trigger or
cascading update or delete is defined on one or more member tables. "

However, I'm able to update a partitioned view, and from looking at the
plan, only the table relevant to the update is updated.

In addition, the SQL 2005 BOL contains a topic "DML Trigger Execution and
Partitioned Views" that describes the difference between SQL 2000/2005
partitioned views with triggers on base tables.

Can someone clarify the above statement? Based on my observation and the
2005 BOL topic, triggers on base tables do not appear to cause a problem with
partitioned views.

Thanks

random select a row based a weight column.
Timeout expire
Optimize this query
How can I insert a new field between existing field?
store results over network