It took me a while to realize the person in question was conflating KMS with TDE. Because I pushed back on using TDE on our specific SQL 2012 environment, they...

Could urgently use some help here, please. https://www.sqlservercentral.com/forums/topic/encrypting-sql-2012

So glad it did.

Completely missing the point, Phil.

It's not discrimination. You are not being forbidden from attending these conferences. You are not incapable of getting jobs or networking because of your gender or...

• This reply was modified 3 years, 2 months ago by  Brandie Tarvin.

Can someone tell me why this isn't horribly racially prejudiced?

https://www.eventbrite.com/e/black-is-tech-conference-2021-tickets-149570987851

Can I open a "White Is Tech" conference without any ramifications?  I never would, though.  THAT would be racist.

Can...

Oh, FOR HEAVEN'S SAKE!

It was executing the query under the context of msdb, not the original database, so the query needs to have the MyDB prepended to the dbo.MyTable.

<headdesk>

I used...

Well THIS is annoying.

I have an SSIS solution / project saved that is set to DontSaveSensitive. All the packages under it are saved as the same. Last week, everything was...

So here's a random thought based on your last post, Steve. If this is the longest thread in the world, how do we get it into the Guinness book of...

I find myself wondering how many people who frequent this website have gotten the dreaded bug and are unable to return for ... various reasons. I hope everyone is doing...

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