I had this error as well with one of my jobs. When looking at the history of the job, I would see "The step was cancelled (stopped) as the...

It is very possible that transactional replication was setup at some point in time. I just took over the db recently and the only replication that was setup was...

I was able to fix my issue. Mainly due to the other post and responses from Gail gave to it.

- I removed the snapshot replication that I had setup...

Thanks for your responses. I will look into both ways. I will also try to hunt down the QOTD.

thanks

rusty

Thanks for you response.

Unfortunately I do not have an architect to consult but in future design changes I agree that it is probably best that we consult one. Thanks...

thanks for the reply.

i currently have snapshot replication setup because all that was needed (originally) was a refreshed copy of the table. Now they want to add additional columns...

I probably should have mentioned that I am not restricted to just snapshot replication. I chose to use it because the table being replicated doesn't change often and where...

Hari,

I had a similar issue as well, and your answer of checking the "keep Identity" worked, thanks. Do you know if by doing this the next record entered into...

Crispin,

I was having the same issue and your response of using expressions on the precedence constraints proved to be very helpful for me.

Thanks,

rusty

Thanks, I will give that a shot.

Thanks for your response.

So for past db versions I will have to do a little manual work but for the future I will do the following:

-add a field...