CREATE TABLE MyUsers( dbname VARCHAR(200), principalname VARCHAR(200), principalSID VARBINARY(MAX))
INSERT MyUsers
exec sp_MSforeachdb 'select ''?'', name, sid from ?.sys.sysusers'

Glad you liked it

Yep, grab the substring, compare length with length of missing Xs.

I'm not completely sure if I understand. Do you mean that given a date, you want to sum all the reviews conducted and the reviews passed. However you need to...

Is that the message from job history?

You should ensure the job creates a log, and examine that. The insert might fail, but that won'd necessarily fail the job....

Here might be a better way to check how Sean's code works. I use tsqlt for repeatable testing. You could certainly download the framework, which would allow you to test...

My kid did a Python course and then another programming one. I think they did a good job teaching programming fundamentals, but not for the real world. No VCS, no...

Yeah, the escaping the tag sequence for C# is broken. I'll edit the one in the forum

Maybe capture the execution plans as well and try to see there are material differences in estimates, in row counts based on what you know about the data.

You have locking issues on the publisher? I'm trying to understand because it's not clear what's going on. You mention initiated from backup or snapshot, but those are initiated on...