Nooooooooo, I was hoping not to manage anyone but myself.

Properties for the role, securables tab.

Lynn is asking about the service accounts, not the host computer. Are you using domain accounts.

Mirroring is pretty cool. However it's like replication in some sense. While it's working, it's great. If it breaks, it can be hard to fix. Often easier to just reset...

Thanks for the feedback. I like them too and would like to keep them going. Pass the word so others click and get the read count up.

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