Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Replication (2005)  SQL2k5 to SQL2k8

Author  Topic  BigSam Starting Member 30 Posts Posted - 2010-02-05 : 09:34:01 I've implemented transaction replication (push) between a SQL2k5 system & a SQL2k8 system, over the Internet through a VPN tunnel as part of a site relocation process. All but one of my databases are replicating fine. The one in question attempts to perform the initialization - it creates the tables, stored procedures, etc., but then gives an error when it attempts to copy the data. 'You do not have permission to use the bulk load statement.' I'm not sure what's causing this. I've checked the SQL account at the publisher & subscriber - it has dbo role at each site. Any assistance would be appreciated.