What does the Partitioned view look like?
Base table structure inclusive of Keys?
UPDATE statement you are trying to issue?
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Mike Torry" <MikeTorry (AT) discussions (DOT) microsoft.com> wrote
Quote:
When try to update partitioned view, I get error: The view cannot be
updated because its disallowed construct.
Why this happen? How to fix it?
Thanks for reply.
-Mike Torry |