I am tring to apply snapshot for transactional publication - snapshot is created and when distribution agent delivers, it succeeds till it reaches the bulk insert for our one table 'xxx' - when it reaches this stage the error is:
Could not bulk insert because file '\\ccc\d$\Data\MSSQL\ReplData\unc\CAIN_BingoCafe_T P_TRANS_BingoCafe_TP\20031119040134\casa_creditcar d_trfff47d64_135.bcp' could not be opened. Operating system error code 1326(Logon failure: unknown user name or bad pa
(Source: EVE (Data source); Error number: 4861)
Why would it need different security options for one file out of the whole snapshot?
If anyone can help, it would be greatly appreciated...
no, when viewing session details at least 15 other tables had successfully bulk copied their data, then always fails on that one - though I think it may be the last one and it is actually failing to wrap up the entire task (perhaps with xp_cmdexec), not just bcp that file...
have made some adjustments, and am waiting for snapshot to generate again...