Jeffrey is correct. Ownership has nothing to do with permissions transferring. It means certain permissions are there for the owner, but means nothing for the schema or role.

check your event logs for a more detailed reason

As mentioned, SQL Server uses the memory is needs. If that's too much for your server, then you might run slower, in essence you have poorly performing code or not...

What's your project? ASP.NET might be the easiest.

If it's just reporting, SSRS fits.

If this is from a maintenance plan, you need to check the maintenance plan log for the reason. If it's a script of some sort, are you manually testing that...

Haven't seen issues, but I'm W7 Ult as well.

Ultimately I'm not sure you can do much other than revoke their account. You could make it difficult, put some limiter on the number of calls/hour or something else. But...

Can we perhaps send the customers and OPs through DBCC TimeWarp instead? Move them to tomorrow, 2020?

Yes. You can't get around it. Either you send the changes through in the log with backups (log shipping), log reads (database mirroring), or a full backup (reset log shipping).

The...

Ben,

You bring up good points. There are some protections against copying files (TDE), but physical access is an issue. However these days, lots of remote access allows you to log...

Thanks, I appreciate the complements. Nice to know that I'm still answering a few that you don't know. I suspect fewer every day

Perhaps I'm selling myself somewhat short. I know I do help people, and try to give them good info, but I'm certainly not the highly technical MVP that some of...

If you transfer the rebuilds, those logs and the rebuilds, transfer to the standby. It's a lot, but it's probably less than sending over the full again.

Nope, no crossing the line. Polite statement and I agreed with it.

Didn't see that, but please do.

I was tempted to leave it. I'm still waiting for someone to go for an interview and have one of these comments come up. Especially...