Well, THAT was a pain.

As Mr. Monk would say, "Here's what happened..."

Somehow, several members of one team (Team A) got added to the security group of another team (Team B)....

The individual users don't exist on the server. They are part of a windows login group, which is not returning results and erroring out.

I think I'm going nuclear. I've removed...

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...

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...

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...

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...

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.

It's late, so I might be missing something here.  Are you saying...

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 

• This reply was modified 4 years ago by Brandie Tarvin.

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...

Don't forget if you use Sprint for cell phone service, you're now T-Mobile and need to update stuff.

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...

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...

Quick question, all. Which do you prefer to use... CyberArk or Hashicorp Vault?

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...