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, 6 months 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...

That is a bit of an unfair metric. There...

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

This is me posting something stupid because it's been a long week, I need to do something incredibly stupid, but also not get bad attention over my need to rant....