The only way to do this is some sort of looping mechanism that checks each table/field that matches the datatype and then return results or store them in a table....

Please post a repro with DDL for a table, some insert statements and then a query. Please format code using the "Insert/edit code sample" button in the toolbar.

Which server gets updates and which gets restarted? It's unclear from your post. I assume you mean the guest gets restarted, but not sure.

I don't know that I've seen this,...

I can't remember most days which day it is. Mostly because I think it doesn't matter and then I don't pay attention. I check the display in my monitor (from...

It is a logical file name, but from my reading, that is bound below the Filegroup. There isn't a Filegroup for the log.

Yes, I'd certainly use a separate account for this. Should be able to be a backupadmin and then perhaps file system rights if there is a copy involved.

I don't see log file listed here: https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/extended-properties-catalog-views-sys-extended-properties?view=sql-server-ver15

Haven't seen that, and it shouldn't matter. During the backup process, if you are writing to a remote share, I don't think permissions are rechecked in midstream. It's possible some...

You will need jobs on the DR instance, disabled or checking for whether this is the primary replica before running.

Thanks, all. I do try, as do my fellow advocates. It's a great job, and I hope we continue to do it for a long time.

You can look for filestream on tables, which is not supported in Azure  SQL database. The list of things not supported is here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-features

I haven't dealt with Access attachments, but I'd agree a separate table is needed. These might be docs in the file system, with a pointer in the Access db. FileStream...

My apologies. I started to reply yesterday and got sidetracked.

Here's my view. I'm not a lawyer, auditor, or regulatory reviewer. Your job is to be compliant with SOX auditing. From...

The formatting of lines was a render issue. Old coding v new coding, and it took time to fix. Despite what you see here, this isn't a high priority item...

I'm sorry you find these hard to use. We've adopted different choices for software over the years, so old posts might reference things that no long exist. It's not practical...