Thanks again for your input.

DK

Thanks for your feedback!

Roy,

Thanks for the reply, that is a good guide. I ended up deleting the whole setup and rebuilding it and it worked. However, I would not have that luxury in...

I am sure of the username/password. I am getting this in the log: Error: 18456, Severity: 14, State: 6.

Isn't this in conjunction with using a windows account as a sql...

Did you check the job history for the distribution agent? It is probably retrying and every couple of minutes, but it will have an initial step that did not complete,...

Well it wasn't a victorious moment, but I ended up giving the domain user admin privileges and it worked.

Thanks,

DK

Thanks for the help, it did not run at the next scheduled time. I disabled the schedule, but other than that made no other changes. Not sure if disabling the...

I see a typical run of the job, as if nothing had changed. All the step start and complete.

SQLRNNR,

Thanks for your reply. I can not find any other agent job that is calling this snapshot agent job. Any ideas?

Thanks again,

DK

Thanks for the replies happycat59 and MysteryJimbo! Should I use the example script from the link below for adding a table to the publication?

http://msdn.microsoft.com/en-us/library/ms173857.aspx

My table addition has no...

Thanks for the reply David,

It is a bigger file but you are right, it will not take a day to copy.

Thanks again,

DK

Thanks for the replies MysteryJimbo,

Those are helpful.

DK

Thanks happycat59,

It is transactional, and it is ticking away happily.

Thanks again,

DK

Thanks to all for your time. I appreciate your comments.

DK

nivek-224024,

Thanks for the explanation.

DK