Viewing 15 posts - 121 through 135 (of 9,725 total)
At the moment, configuring extended events is not something I can do. We need to jump through hoops to make changes to production servers and this is a high priority...
April 5, 2024 at 12:05 pm
Yes, I was messing around and forgot to change xlxs to csv.
Oddly, I'm not getting a file created with your posted suggestion. I'm going to noodle around a little more...
April 4, 2024 at 4:30 pm
Sigh. I wish I could take comfort in "Your emergency is not my emergency." Sadly, my job makes other people's emergencies my emergency.
Any powershell gurus around? I'm still in my...
April 4, 2024 at 3:02 pm
YAY! WITH EXECUTE AS OWNER solved my issue. No extra permissions required, no impersonation permission granted to the user group. Thank you all so much! I appreciate you.
November 1, 2023 at 5:55 pm
AOR = Area of Responsibility. Think of it like departments or smaller chunks of a business division. I am separating out their jobs from the jobs owned by the DBAs...
November 1, 2023 at 4:03 pm
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
Viewing 15 posts - 121 through 135 (of 9,725 total)