This is a test post as we've had a few issues.

Thanks, Thom, and sorry for the hassles. We're ironing them out slowly.

Vodka

I'll see if I Can get some loaded. In the meantime, if there are specific levels you're looking at, I can try and track down the files. Send me a...

Here's what I suggest. Create loose coupling, since your central server could have issues.

Gather the info you want and have that stored on each machine. If you want to know...

The service account is the same as any other account. They have permissions or they don't. It's possible they set permissions for the agent account rather than the service account,...

The new forums don't allow this by default. There are a few plugins. I'll file a note to look at them

Added this to the bug for styling. I'm torn on this, as sometimes really long code starts to break down in styling. If we can get a side scrolling section,...

Here's another test. I want to get this URL (https://www.sqlservercentral.com/forums/topic/no-markdown#post-3160892) to rewrite.

Yeah, it comes down to some of the choices in picking software that works in different ways. For these forums, limited choices and lots of code already written that uses...

Stairway Series: https://www.sqlservercentral.com/stairways

What Grant said, and practice different skills, see what you like and have an aptitude for. Ask lots of questions, what people do in their jobs, what their...

I tend to agree with Grant's views. I usually use surrogate keys because what I find is that many business people swear there's a natural key, and there is, until...

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