If space isn't an issue, I'd restore a backup to the other server and drop the things you don't need, keeping only that table

It depends on how your replication is architected. I'm pretty certain the subscriber only needs to be able to talk to the distributor. Any "external" server needing replicated...

I would check 2 things:

1) On your SQL Server, have you allowed remote connections to the server?

2) In your linked server set up, did you set the Data Access to...

Table A: (Master)

PCID (PK)

ComputerName

OS

OSVersion

Manufacturer

Table B:

PCID (FK)

SoftwareName

SoftwareVersion

SoftwareLiscencekey

Installedversion

?

Or you could go really crazy and create an OS, Manufacturer, Software table - but that'd probably be overkill 🙂

I think you're on the right track with the "meds", get them and relax a bit, or meet with a therapist 😀 Then again after reading your mini-novel, maybe both...

Tables that involve a lot of "changing data" aren't always the best candidates for Transactional Replication. In the past we had a table for "Transactions Not Processed", or a...

Is there any chance that your subscriber databases are near the maximum file size that's been set, and due to the amount of data being replicated, the files are constantly...

Thanks for the clarification, it is greatly appreciated

As long as you're the person who's responsible for the outcome, I don't think it ever goes away.

Recently, in our busiest Production environment, I had to relocate several large (+1TB)...

In trying MS's adive (re-installing the 2.0 framework), it won't allow me to do that - it errors out stating it's required and cannot be uninstalled - any suggestions?

Glad the question was well received 🙂

Do you have a linked server set up and allowed remote connections to it?

Note, it's only required for the very first time either you or the account that will be used runs it. If you ever change the proxy account you'll need...

Lutz, ironically enough, that's the exact same piece of software that we use (TotalHTMLConverter) and unfortunately, you will need to use the code I provided in order for it to...

@@ROWCOUNT is overwitten after each statement is executed (its scope is therefore lost). Create a variable before the transaction declarations and assign the @@ROWCOUNT to it for each statement...