Its not 100% guaranteed, but you can look through sys.sql_modules in each databases, query where the definition is LIKE SELECT and NOT LIKE INSERT UPDATE DELETE.

As I say...

So for the hour, you just want...

And how are you calculating the hourly size?  Are you only bothered about the last hour, every hour, do you want 24 columns one for each hour, is this done...

That query...

Hi Manu

I suggest reading through https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/monitor-log-shipping-transact-sql once you have got the query to display the information you require, you can then code it in an email to be...

As these are interview questions, please post what your answers where and the people here will guide you on the rights and wrongs, we do not give the answer to...

Sounds like the log backup is corrupt or incomplete or the primary database has become corrupt

What is the full output of the below when run in the database...