Thank you Jeff, this is working as I expected.

Really appreciate taking the time out of your busy life to help out.

Hi Jeff - just checking to see if you got a chance to test it.

Thanks Jeff for the reply.

--Working SP to send email for Database mirroring report using LinkedServer OPENQUERY

USE [master]
GO
/****** Object:  StoredProcedure [dbo].[Mirroring_Status]    Script Date: 4/13/2022...

Attached the script in .docx type.

select @@version - Microsoft SQL Server 2019 (RTM-GDR) (KB4517790) - 15.0.2070.41 (X64) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: )

Also, attached the script.

Thanks in advance.

Thanks Sue.

So, you are saying a user with securityadmin server role and db_securityadmin db role is not enough to create/add a permission to another user without db_accessadmin privilege...

Thanks Sue for the quick response.

I will look into this. Thanks again.

Hi John, Thanks for reply.

Yes, this is transactional replication....and I was told no inserts or deletes since last initialization.

yes, this is good, thanks Scott.

I found this query but I only need tables/indexes bigger than below requirement

Any table with data > 800 MB not compressed

Any index with disk usage > 80 MB not compressed

Any...