Just an update.. we may have found the issue in the scsi disk controller.. updated it from LSI Logic SAS to VMWare Paravirtual.. which is the recommended setup for sql...

Yeah, that was my thought, neither of these products are uncommon so its pretty nuts that I'm the only one I see experiencing it.

They are not on the same host as one is production and the other is a test environment. however all hosts are mirrored.

Thank you sir, very much appreciate the assistance here.

No, sorry, both servers are in vmware.. they are both windows server 2016 with sql server 2016 installed both are SP2.. one is CU 3 one is CU4.  On the...

Yeah for sure.. and I was looking over the chart below.. and don't see anything specific for viewing filters..

Chart of SQL Server Permissions

I suppose you could go the round about way of creating a stored procedure where you parameter the table and index name and have it execute as you but .....

I did look at that .. but I don't believe this is the case.. the reason being is that yesterday, I took a backup of the unencrypted database.. restored it...

Welp.. Never mind.. apparently it can't decrypt while in single user mode, I guess because I'm one user and the server is a second user;) Sorry, I'm still a noob...

So, I verified that it does seem to be the differential of the VMware snapshots that was causing the issue ... we are going to be moving just to doing...

Your guess makes a lot of sense, but does not apply here, these databases are all very small databases, the full back up takes less than 10 minutes to complete.