I'd use the STRING_SPLIT() here, which is efficient for use. If you need to put this back into the column, you'll need to use string concatenation to get the result

I'll say that most of these books are 90% the same. The authors tend to follow what others do and so they get formulaic. I'd get a sample and read...

This, Dba-StartSQLJob, will help
https://docs.dbatools.io/#Start-DbaAgentJob

I'd add a PoSh step and use that to call a SQL Agent job on another server. That way I could actually see the execution metrics on both sides, with...

I'd go with Access.

Haven't seen anything on that. It's not on the @(local variable) page that I see.

Then again, I don't think it's a good idea. Just an interesting question

Not sure where sysname comes in here with "all variables", but am I missing something?

Glad you found it. I know that can be maddening.

I have no idea why proc fails and sql works. That's why I asked to check versions. I have had versions seem to rev underneath me. Building a second proc...

@jason

I do think EAV has a place, especially in the real world. We don't live in a perfect world, especially with regard to requirements/specifications and time. We do...