April 28, 2007 at 12:25 am
Hi guys,
I have restored my database on a SQL 2000 server and this database contains a partitioned view. When I am running my application I am getting the following error:
"Partitioned view <view_name> is not updatable because the source query contains references to partition table [table_name]."
The surprising thing is that the application is working perfectly on the original database but is giving this error on the restored database on another SQL 2000 server. In fact both the servers are identical.
Can someone help me out here as to why this would be the case?
Thanks in advance!
Kyrus
April 29, 2007 at 12:27 pm
This is the second time I have seen this error and the answer is rather simple Partioned Views are based on the Original Union ALL views which are not updatable per the Algebra definition of Union but the Vendors like Microsoft found a way to update them. So they come with very strict rules you must follow to be able to update them, I am assuming something may have changed like the SETs used to create the original view so try ALTER to rerun the same code so it is native to the new database or drop and recreate it in a sandbox then move it. Run a search for Partioned View in the BOL and you will understand what I am trying to explain. Hope this helps.
Kind regards,
Gift Peddie
April 30, 2007 at 9:54 pm
Hi Gift,
Did try out your solution but it did not work out. Am trying some other ways to solve this problem.
Anyways thanks a ton for helping.
Best Rgds.,
Kyrus
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply