SQL Server Performance

View Error

Discussion in 'General Developer Questions' started by amitm79, Apr 19, 2005.

  1. amitm79 New Member

    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
  2. dineshasanka Moderator

    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

Share This Page