sql server replication: Hi,
I use FTP Merge Replication over internet.Two weeks ago,I
created the publication on the development
server .Everything was working fine.
But when I ran the snapshot jobs for the second time, the
jobs failed.I ran them again in order to understand the
exact error with OutputVerbosal 2, I see that the snapshot
agent applies all table,stored proc etc. scripts,but
When it strats to bulk copy from tables,it immediately
gives error, In other word it can not bulk copy when there
is data in MSMERGE_CONTENTS(But when I DELETE ALL RECORDS
FROM MSMERGE_CONTENTS, SNAPSHOT JOB RUNS
SUCCESSFULLY)...The details of this error is given below;

In error log, after the message
"Bulk Copying snapshot data for system table
MsMerge_Contents", an error occurs with a message;

"The process could not bulk copy out of
table 'cont00355CADEDF243C791E95897E0519081'."
Erorr Details
Internal SQL Server error.(Source: Error number: 8624)

Is this a security issue related with bulk copy OR table
rights?

Regards,
Belgi Ozen

(Windows 200O,Microsoft SQL Server 2000 - 8.00.818
with Service Pack 3A is installed on the server.)

Belgi
I doubt this is a security issue. To verify this, check that the sql server agent is running as a sysadmin login (or more easily the same network login as sql server service), and check that the publisher should impersonate the sql server agent
Regards