SQL Server has the file(s) locked, so it can't rename anything. Neither can you. You need to stop the database engine for that datbaase to rename the files. You can...

You're asking for exact matches, which means exact matches. Are you tolerating matches if there are no spaces? If so

replace(HOC.Desc, ' ', '') = replace(Lo.Desc, ' ',...

Email is email. You need a client that can read from an address.  I would never have SQL Server receive the email because rogue emails to this address could open...

+1 for Grant's advice to use XE.

SQL Server will automatically uncompress the files. This is to ensure compatability.

As a near-senior citizen, I’d like to know how one goes about protecting and remembering 30 or 40 different accounts/passwords. Password vaults are only as secure as the password...

Enjoy. I think native intellisense is...

Hmm....seems we (or at least I) don't have the ability to flag posts as spam anymore. Other posts on that thread can be reported. What's the deal here???...

Seems like that works for me.

I think Eddie has it correct. Check with MS, but the general rule of thumb is that

a) you need SA

b) you cannot use the secondary for anything. No reads, no...

I think this will work, but you'd need to have named instances. You can't have things fail from 2016-> 2014. This should be like any other cluster that has multiple...

Might also look at sp_Blitz. These scripts are sometimes more helpful in debugging things: https://www.brentozar.com/first-aid/

I lean towards what bmg002 said. Without more info, hard to know what's wrong. Have you added other fields? When you get this message, do you check the PK/FK violations?...

Voted and commented.

No reason to push back on TDE. It's low impact, easy, and it prevents incredibly silly losses of data due to someone copying a backup file to the wrong place.