Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 View error

Author  Topic 

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-05-07 : 11:42:08

getting error when updting VIEW

UNION ALL view 'a.dbo.a'is not updatable because a partitioning column was not found. Severity 16 State 12 Example Line 194

Please advice..

Thanks,
ServerTeam

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-07 : 11:47:48
I think you can make use of an INSTEAD OF trigger for performing the updation of view.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-07 : 11:53:23
similar discussion here too:-

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1683787&SiteID=1
Go to Top of Page
   

- Advertisement -