Viewing 15 posts - 196 through 210 (of 9,720 total)
HMMM... We use groups in SQL Server, so the individual login isn't working. And the group gives the same error.
Msg 15406, Level 16, State 1, Line 1
Cannot execute as the...
August 23, 2021 at 7:04 pm
Another thing to check is linked servers. If a linked server connection connects to that instance as a user who has permission to drop and create objects AND you...
August 23, 2021 at 4:37 pm
I assume you know which login dropped/created the procs.
and assuming you are a SYSADMIN what output do you get out of these
execute as login = 'loginname' SELECT * FROM...
August 23, 2021 at 4:32 pm
There is no schema owned by this group. But you brought up an interesting point. Sometimes groups become owner of system created database schemas, so I double-checked. The group does...
August 21, 2021 at 9:33 am
I am getting really annoyed with this "link to the post takes me to the second last page of the thread, not the actual post" issue.
August 21, 2021 at 9:19 am
It's Friday. I've been overwhelmed for several days and now I'm just confused. Help here appreciated:
https://www.sqlservercentral.com/forums/topic/mysterious-ability-to-drop-create-stored-procedures
It's late, so I might be missing something here. Are you saying...
August 21, 2021 at 9:18 am
It's Friday. I've been overwhelmed for several days and now I'm just confused. Help here appreciated:
https://www.sqlservercentral.com/forums/topic/mysterious-ability-to-drop-create-stored-procedures
August 20, 2021 at 8:05 pm
So my interview question of the day would be - "tell me about logging in SSIS" or "how do you write to the log table in SSIS?" And if...
August 19, 2021 at 9:44 am
Don't forget if you use Sprint for cell phone service, you're now T-Mobile and need to update stuff.
August 19, 2021 at 9:41 am
If they put Masters in the Basic requirements, HR will never forward anyone who doesn't have it, regardless of experience. Having it in preferred also gives them the option...
August 17, 2021 at 2:03 pm
This is from a job posting that another department in my company put together.
Basic Qualifications
Bachelor’s degree in data science or related field and 2+ years of related experience Proven...
August 17, 2021 at 1:57 pm
Quick question, all. Which do you prefer to use... CyberArk or Hashicorp Vault?
August 17, 2021 at 1:02 pm
I stopped using Stack OverFlow (except when it pops up as a Google search result) when I got bashed for asking a question. I can't remember if my thread got...
August 17, 2021 at 12:51 pm
How about the legions of people that write blog posts where comments are either disabled from the git or eventually disabled?
That is a bit of an unfair metric. There...
August 15, 2021 at 5:25 pm
FYI: Allstate has a remote-work-from-home mid-level DBA contract to possible FTE hire position available through Ranstad. I don't have the job description or a link to the job available unfortunately....
August 13, 2021 at 6:46 pm
Viewing 15 posts - 196 through 210 (of 9,720 total)