Viewing 15 posts - 121 through 135 (of 9,720 total)
OKAY. Now the WITH EXECUTE AS <user> / OWNER is the syntax I could not for the life of me find. I might try that.
The security is being implemented across...
November 1, 2023 at 2:49 pm
Another approach would be to sign the stored procedure and create a certificate user in MSDB with appropriate permissions. It can get a bit involved but the following may...
October 31, 2023 at 7:18 pm
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...
October 31, 2023 at 7:17 pm
I would think you would want to use "EXEC AS" on the proc itself rather than inside the proc.
Sadly, without giving IMPERSONATE to the users, I cannot let them...
October 31, 2023 at 7:15 pm
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...
October 31, 2023 at 11:58 am
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
October 13, 2023 at 12:35 pm
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...
September 13, 2023 at 12:31 pm
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...
September 13, 2023 at 12:29 pm
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...
September 5, 2023 at 6:35 pm
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.
August 31, 2023 at 7:30 pm
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...
August 23, 2023 at 4:39 pm
As we're sharing "new job" pains, we're likely going to be are taking responsibility of IT services for our parent company in the month months (years).
Ok... let's...
August 23, 2023 at 4:16 pm
Hey, binary still has legs on it!
@=)
August 23, 2023 at 1:25 pm
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...
August 23, 2023 at 12:27 pm
Trying to imagine a scenario where I worked with Jeff Moden and tried to call out his code...
Jeff, Tally tables aren't working and this RBAR thing is RIDICULOUS. No...
August 23, 2023 at 12:21 pm
Viewing 15 posts - 121 through 135 (of 9,720 total)