Hi All, I am getting the following error while trying to insert data using a view. Server: Msg 4436, Level 16, State 12, Line 2 UNION ALL view <View Name> is not updatable because a partitioning column was not found. My view is a partitioned view based on multiple tables with appropriate check constraints. Any ideas why i am getting this error? Regards, Amit
check this. exactcly the same problem [urhttp://dbforums.com/archive/70/2002/05/1/368267[/URL] quote:Originally posted by amitm79 Hi All, I am getting the following error while trying to insert data using a view. Server: Msg 4436, Level 16, State 12, Line 2 UNION ALL view <View Name> is not updatable because a partitioning column was not found. My view is a partitioned view based on multiple tables with appropriate check constraints. Any ideas why i am getting this error? Regards, Amit
