|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > URGENT: Can't Apply Snapshot with data in Publisher
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
URGENT: Can't Apply Snapshot with data in Publisher
|
|
| viktor 2002-10-30, 4:23 am |
| I have a merge publication, when I apply the snapshot with data in the
Publisher, It fails when bulk inserting into one of the tables, If I see the
detail of the error, it says: Bulk Insert can't be performed, The massive
data flow is not ordered (In Spanish: "No se puede insertar masivamente. Se
especific incorrectamente que el
flujo de datos masivo est ordenado.")
it happens so much if the subscriber has tables or not.
thanks.
| |
| Haijun Yang [MS] 2002-10-31, 10:23 am |
| Hi,
Can you give me the error number?
If it's 4819,you can try changing the index of the publishing table primary
key to non-clustered:
-------------
1) Right click the table in SQL Enterprise Manager, choose "Design Table"
2) Click "Set primary key" button to drop the previous clustered primary
key.
3) Highlight all columns used to composite the primary key, click the "Set
primary key" button again to create a new primary key.
4) Click "Manage Indexes/Keys..." button. On the "Indexes/Keys" sheet of
prompt dialog, uncheck "Create as CLUSTERED" box.
-------------
Regareds,
Haijun Yang [MS]
Microsoft Partner Support
This posting is provided 'AS IS' with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security
|
|
|
|
|