You can try:

sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset = 1 

That's what I've done, but to solve a slightly differnt problem. I...

Most tables could be copied via linked server, but a few were getting an OLEDB error.

The problem ended up being that there were triggers on the target tables. I had to...

You might get better feedback if you post in one of the SQL subfolders instead of the Notification Services area.

You might get better feedback if you post in one of the SQL subfolders instead of the Notification Services area.

Good Points.  We went through something similar a while back, trying to import Excel files with garbage in them. At first we tried fixing it in SQL, but then said...

We have 2 different types.  One application has varchar 19, the other is char 50.

In both cases they are encrypted and have non-numeric characters.

 For CR-LF removal, I do something like this:

update

My_Table

set

ColumnA = replace(replace(ColumnA...

There are a few other longstanding bugs on this forum that are annoying .....  oh well

"....I HATE IT when the system eats my message whilst I'm writing it!...."

You mean when you type a long post, and then it gets wiped out for no reason...

You might get better feedback if you post in one of the SQL subfolders instead of the Notification Services area.

You might get better feedback if you post in one of the SQL subfolders instead of the Notification Services area.

You might get better feedback if you post in one of the SQL subfolders instead of the Notification Services area.

We run many of our "non-critical" databases in SIMPLE mode, but our production databases are definately in FULL mode.  Every database has a full backup every day.  You should be...

And you should understand that any database in SIMPLE recovery mode can only be recovered back to the last full backup. So if you did a full backup on Sunday,...

Can you give any more detail ?  What part of replication is getting blocked ?  I would think it's snapshots contending for the same tables as users.  Perhaps you change...