btw: if you also want an inventory of all members of db group db_owner in all db, you'll need to provide the account Connect to all db.

use...

probably.

To see the actual db owner of a db, you only need a login.

CREATE LOGIN [test] WITH PASSWORD=N'123Test...........', DEFAULT_DATABASE=[master];

When logged in as that account, the following query...

Did you try:

Select 'Restored' as source, AppUser.UserId, usergroup.Name, AppUser.UserName
from AppUser
INNER JOIN RestoredDatabase.dbo.AppUser_UserGroup 
    ON AppUser.UserId = AppUser_UserGroup.UserId
INNER JOIN RestoredDatabase.dbo.UserGroup 
  ...

Glad you already got a solution.

The flaw / bug in my script was that I hard coded "'production' as source,".

If you remove that "source" column from both queries, you'll get...

Did you try:

Select 'Restored' as source, AppUser.UserId, usergroup.Name, AppUser.UserName
from AppUser
INNER JOIN RestoredDatabase.dbo.AppUser_UserGroup 
    ON AppUser.UserId = AppUser_UserGroup.UserId
INNER JOIN RestoredDatabase.dbo.UserGroup 
    ON...

Can you post the exact error message?

After long hours, days and weeks the system back to healthy state. The biggest problem was bad developers code that had to be changed. That was killing...

Isn't that the whole "reason to be" for Ag's ?

When the partner instance comes back online and is visible to the primary instance, it will pickup log-processing from primary to...

Capture failed logins using extended events !

This may get you started: "Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events" as it gives you more...

Jep .... that's also part of life 🙂

I copy-pasted your text and commented all but the ddl and the queries.

Works just file.

Off course, in SSMS you need to keep the consequences of any "GO" line in mind...

Talk with your db's consumers if they changed usage / implement new stuff / have faulty processes recently / ...

btw: If you hover over the icon, you’ll get an explanation of it

explained at: "What is a contained availability group?"