Can you please post your query?

Why the log reader agent?

This was my original thought. Perhaps we...

Could you not turn this into a stored-procedure and pass in the parameters using SSIS's "?" flag for parameters? I believe the syntax is EXECUTE dbo.MyProc ?, ?, ?...

I use Idera SQL Safe for our company's backup solution, if you are looking for a solution with multiple servers they will really work with you on the price/server (comparable...

To answer your questions:

1. No

2. No

3. It appears to be the same table(s). We were going to try and drop the articles and add them back in to see...

Thanks Lynn, yes I was aware of this occurring when you do it via SSMS but I was more curious as to why the same thing doesn't happen when you...

Query the distribution database:SELECT article FROM distribution.dbo.msarticles WHERE publication_id = X order by article_id

This is interesting - When you alter a column i.e.(increase the size) in SSMS using the GUI in it creates a temp table, locks the temp table, inserts all the...

I forgot to mention: on the production server, transactional replication and log shipping is set up (which is not running on the other DB were I was successful running the...

At our shop the versions where this error randomly occurs are:

ProductVersionEditionProductLevel

10.0.4000.0 Enterprise Edition (64-bit)SP2

ProductVersionEditionProductLevel

10.0.5500.0 Enterprise Edition (64-bit)SP3

If you see my prior post, it won't allow you to uninstall and reinstall the framework unless you completely remove SQL Server and it's components...so i didn't go that route....

Nothing seems to work other than a complete reboot of the server (unfortunately), and it returns randomly...

Are you able to print the results of the print here?

Instead of EXEC (@SQL) , please DO a PRINT and then post the results so we can see the output