Hi All,
In the database(SQL Server 2000), we are using horizontal partitioned view(nearly 15 tables are joined with UNION ALL). Everything were fine, until we changed the CHECK constriant of one table . Now the view has become not updatable. It is giving error as PARTITIONED COLUMN NOT FOUND
We tried to drop the view and re-create it, drop constriant->view and create constriant->view. None worked. The constraint added is very much correct.
I think there is some logical stuff regarding partitioned view, which I am not aware of.
Can anyone guide me or help me regarding this. I have searched a lot in the net, still not able to find any solution for this.

Thank you.,