I am a newbie to this, so patience with me please.
I have just set up transactional replication between 2 sql server 2K servers. I used the wizards (so no mistakes made by my faulty TSQL!) and all seems fine - the snapshot runs fine and creates the database on the object server, then the agent sits there waiting for a change - GREAT. As soon as I make a change in the database to the data in one of 3 tables(via Enterprise Manager) the agent kicks off. It is a push to the object server, but fails with "Syntax error or access violation". I am severly confused here - is there something outside of the wizards that I should have done? I can't find anywhere that will give me a better idea as to what is wrong either.
ANY help will be gratefully received.