I ended up using OpenRowSet for sp_replmonitorhelpsubscription.

For the other repl cmd sp I ended up reengineering the proc pulling out just the pieces of code that I needed.

Thanks,

Nick

Any solution to this problem. We're trying to do the same thing?

Nick

So I found one more thread that says to turn on replication for that db, run sp_repldone, and then turn it back off as follows:

EXEC sp_dboption 'MDS', 'Published', 'true';

EXEC sp_repldone...

Ok, that LSN turns out to be 98 out of 871 returned from DBCC LOGINFO. It has a status of 2.

Regarding DBCC LOGINFO results the first two have a status...

Actually, there is some infor that comes back from DBCC OPENTRAN:

Transaction information for database 'MDS'.

Replicated Transaction Information:

Oldest distributed LSN ...

What is DBCC OPENTRAN shows that there are no open transactions?

DBCC LOGINFO shows 871 records in my case. The first 864 all have a status of 2.

My log file...

You hit it on the head. Show me a company that values there IT employees and I'll go work for them. Until then, I'm sticking it out as a consultant....