Will this work what I stated above?

We currently have 2016 SSMS with a 2016 instance on site.  Just to clarify, we would like to replicate a 2008R2 replication(publisher and distributor) with the 2016 instance which has...

Yes, I am trying to set up a replication alert if the transactional(scheduled every 5 min) records never make it over to the subscriber but have the alert come from...

Ah, I got it finally. I was leaving the Package Location on SQL Server rather than clicking the drop down. Thanks all for the knowledgeable input.

I tried to export the package through SSMS integration services and does not export. Not sure how to do that.

I was looking for changes to the schema and not the values. But thanks for your reply.

I resolved the issue by creating a view and querying the view.

I get error Incorrect syntax near '.00' and Unclosed quotation mark after the character string. I have checked all quotation marks. Any ideas?

DECLARE @xml NVARCHAR(MAX)

DECLARE @body NVARCHAR(MAX)

USE R4W_001

SET...

That worked great but there are repetative dollar amounts. Can you display how to retrieve the exact same information but three distinct dollar amounts.

Ol Hand!! Excellent. Exactly!! Much appreciated.

I got it. Thanks so much djj.

Thanks djj. Would you put the case right before the data field, or could you copy my code and put it exactly where it should go?

I apologize the format of the results displayed all together. But the columns are spaced out in the real results. The columns are item_id, available, Desc, and Expct...