Thanks Ed Wagner.. As per your suggestion results are coming email body two different table format after changed as below coding.

But second table heading joined with last row of...

Pl. find the attached email which is receiving in Email body.. there are two different query that two query output display in email body with line brake separately with heading.

as per above script both heading are merged in single HTML report.

I want two different HTML report in same email body. Pl give some example HTML script.

Thanks

HTML Heading not coming separately in same email report... both heading merged with in single report.

Thanks

First and Second query Result set merged with in single HTML report format. but it is not display separately in email body...

Hi Jeff.. Thanks as per your suggestion after adding as below line multiple Query result comes in Email body as desired but second set of results not comes is separately.

SET...

I have received users report in email with respective data in column order in one database.

The following include two different query in different database for fetching data. but i received...

Hi. Thanks for posting this script for checking database size.

Could you suggestion? how can get all target DB server database size in one single by using your script? if required...

I have searched and found this link https://support.microsoft.com/en-in/kb/2879704 .

this link suggested as below

1. install .Net 4.5 framework on top of windows 2008 R2. which was installed SQL native...

Please help, how windows authentication to connect the web application?

In my case, there are two different server and both the servers are member of same domain group.

SQL 2012 DB server...

Hi Lowell,

1. I turned on SQL browser service then SQL instance does not connect without custom port. it would connect after mentioned port.

2. Does it require and mandatory to create...

Hi Willem G.. Thank you so much for sharing backup report script and monitoring across all remote database in single email report.

1. Full backup configured by thru SQL maintenance...

Hi Satya.. this is excellent script for sharing..

How can I add linked server name in this script for getting backup report in one single format.

I have created linked server, Name...

As below code working and fetching data from remote server but Remote server database name not display..

SELECT DB.name AS DatabaseName

,MAX(DB.recovery_model_desc) AS RecModel

...

Hi Perry thank you..

Let me explain my current multi subnet failover cluster setup..

1. sessions are synchronous mode (both local site 2 Nodes and DR site 1 Node - AG databases)

All...