Path is not passed is it the intention to use a local drive as it’s not specified clearly in the 2nd script.

Bit more info on what it is you’re trying...

I don’t see any reason to be concerned about 3NF reqs here it’s a simple metadata table

What groups are provisioned on the servers with rdp access too?

that is do you see the same AD group in windows admins as you see as syssdmin in the sql...

can’t think of any immediately, the table is small and lightweight.

only the obvious which is the inability to truncate the parent...

It makes sense for azure sqldb, AGs are more targeted at groups of databases rather than single dbs, ok azure sqldb are pinned to a virtual instance for database connectivity...

The best alternative I can think of is a separate table instead of an IsDefault column. This other table has one row with one column, FK to the PK...

agreed, the deployment of a central management server provides this list centrally for all users, adding warehousing capability and harvesting...

If you declare an explicit tran then it is your responsibility to either commit or rollback

Cleaning up uncommitted explicit trans by auto committing them is not something you want

This link should help

https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/contained-availability-groups-overview?view=sql-server-ver16

full backups are fine but diffs fail, is that correct?

Also...

as already stated, its bit surprisng that the database engine thought a transaction large enough to warrant a 30 hour rollback was the least busy transaction. Was this transaction actually...

Glad it helped, mirroring can be paused at the group level and database level.

error number would be helpful

Ok so check the logs you should be seeing error in the restore likely with an OS error number

Recreated this by creating a test SP, queue and service (owned by user test)

Try to drop user and get same message box, this will identify the service name and owning...