Hi,

Does it possible to load data directly into a partitioned view?
or I must fill each table behind the partitioned view myself?

For the moment I receive the error "partitioned view "myview" is not
updatable as the target of a bulk operation"

I've searched on google without any clear solution described.

All my tables are stored on the local server (its not a distributed
partition scheme)

Thanks for your help.

Jerome.

I'd be tempted to load each member table in parallel,

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote

Hi,

Does it possible to load data directly into a partitioned view?
or I must fill each table behind the partitioned view myself?

For the moment I receive the error "partitioned view "myview" is not
updatable as the target of a bulk operation"

I've searched on google without any clear solution described.

All my tables are stored on the local server (its not a distributed
partition scheme)

Thanks for your help.

Jerome.