Posted by Tom Moreau on 05/31/07 21:40

Consider putting an INSTEAD OF trigger on the partitioned view.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Sonny" <SonnyKMI@gmail.com> wrote in message
news:1180647134.671664.320360@a26g2000pre.googlegroups.com...
On May 31, 4:17 pm, "Tom Moreau" <t...@dont.spam.me.cips.ca> wrote:
> You cannot have identity columns in an updatable partitioned view.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canadahttps://mvp.support.microsoft.com/profile/Tom.Moreau
>

In that case, how should I deal with the ID1? I need that column to
be an identity column. Thanks.

• Next in forum: Re: Synchronous Bulk-Copy into two table
• Prev in forum: Re: Help on Partitioning column was not found.
• Thread view: Re: Help on Partitioning column was not found.

[Reply to this message]