Stop. Rewind. Reverse that.

You could query sys.sysservers in master to get the linked servers, then with a cursor you can loop through them.

You'd need to define what you want the trigger to do and we can then help you. As Thom noted, this is flawed code.

Some basics: https://www.sqlservercentral.com/articles/learning-about-dml-triggers

Wow, can I ask how long a journey and #people/apps? This would make a great series of articles if you have time.

And we have a test item. Asked in Slack, and a DevOps deploy to prod: https://www.sqlservercentral.com/newsletter-archive

Yes, a bug is open here. The resource files moved, but the linkages got mangled. Not as simple as I had hoped. If there are specific ones, I Can manually...

Looks like they've been removed or hidden already.

Thanks, will check.

We don't have an index right now. The current site uses a new mechanism, and there is a personalized link for newsletters. We're working to migrate that and render a...

OK, I did some work on this and got an article I'll publish next week, but the short answer is that this is both easy and complex.

I've used certs for...

What does "two line ids" mean? You haven't really explained how you set this up or what the data looks like. It would help to have a small repro of...

If you are missing the newsletter, send a note to the webmaster. Likely something is broken, but we can tell you. Mostly we find that we moved services, so some...

You're going to need to use a stored procedure. I would argue that's modular and worth doing just as much as a function.

This will replicate the index, but the creation of the index should take place on the subscriber. This will cause some workload as the indexes are built and a small...

Our build list shows this as an SP2 patch. There is a release for sp1: https://support.microsoft.com/en-us/help/4293808/security-update-for-remote-code-execution-vulnerability-in-sql-server

Build list:  https://www.sqlservercentral.com/articles/sql-server-2016-build-list