August 29, 2005 at 10:01 am
I am getting the following error when I try to insert data into a UNION ALL VIEW:
Server: Msg 4439, Level 16, State 6, Line 1
Partitioned view 'Test_VW' is not updatable because the source query contains references to partition table '[Test]1'.
August 29, 2005 at 10:17 am
I dropped and recreated the Test_VW but now it's showing up the following error:
Server: Msg 4416, Level 16, State 5, Line 1
UNION ALL view 'Test_VW' is not updatable because the definition contains a disallowed construct.
August 30, 2005 at 5:58 am
Since you didn't post the DDL for the view, we can't tell exactly what the problem is. Open SQL Server Books Online, select the Index tab, and search for UPDATE, partitioned views. That section describes all of restrictions regarding updatable views.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply