One approach I can think of to this is to have the end users insert their job request into a table. Then you have a SQL job that runs...

Sadly, without giving IMPERSONATE to the users, I cannot let them...

Of course, after I posted this, I realized that the user running the proc can't grant impersonate on themselves, so I'm ripping that part of the code out. But I...

From the "Boy, I feel stupid" department, can someone look at and answer this AG question? Availability Group didn't get secondary DB added? – SQLServerCentral Forums

BTW, does anyone know if hardware (ISCSI controllers, CPU, memory) resolves the issues with 2022?

I know. Hardware shouldn't be required to fix bad code... but sometimes poor performance can be...

Thanks for the post about SQL 2022, Jeff. I've reached out to my team and mentioned that we need to fix all the problems we're currently having with SQL 2017...

It's interesting. A few months ago, I had that very same ACE 32 bit vs 64 bit argument with a few people at my new shop. And someone insisted they...

The one I'm looking at has 3 legs and a pink bowtie around its neck. So I must be a little behind you, Phil.

Sigh. Nope. We should be managing dirty reads on the statement level - not the session level - because apparently there may be some statements in a stored procedure that...

Ok... let's...

Hey, binary still has legs on it!

@=)

So I haven't been able to consistently post for a while because stupid issues with website or browser (not sure which, but I didn't actively change anything). And now for...

Jeff, Tally tables aren't working and this RBAR thing is RIDICULOUS. No...

I am not using that silly new name for The Platform Formerly Known as Twitter.

YAY! Website...

I'm not sure. I wasn't the person who did the original server move / install. I will go back and check, though. Thank you for this information.

A brief glance at...