Viewing 15 posts - 46 through 60 (of 101 total)
Hmm...I do get an email except it is blank, empty - when it worked, it did return the jobs that failed, retried, and or canceled... Unfortunately when I run it...
July 23, 2018 at 12:09 pm
The only thing edited out in this script is the email address..See below:
'DECLARE @tableHTML NVARCHAR(MAX) ;
DECLARE @s-2 VARCHAR(max)
SET @s-2 = 'Reconciliation...
July 23, 2018 at 11:09 am
So, I adapted your HTML output script and it appeared to be working perfectly fine - now the output sent by email is a blank page with no content just...
July 23, 2018 at 10:40 am
Is it possible to both the send the result of the query in an email as well as load a table with the same result simultaneously? Do you have a...
July 23, 2018 at 7:47 am
Thanks! This is great....it works. I will adapt your query.
July 20, 2018 at 2:03 pm
Thanks. So I found this script to get the result of the script in a layout like the image attached. However, I get a blank result shown after I run...
July 20, 2018 at 10:42 am
I think the script can be improved. Specifically, you are reading the same table three...
June 27, 2018 at 9:27 am
Thank you.
April 12, 2018 at 8:36 am
My bad, here it is:
Microsoft SQL Server 2014 - 12.0.4100.1 (X64)
Apr 20 2015 17:29:27
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.2 <X64>...
April 11, 2018 at 1:25 pm
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64)
Jun 11 2012 16:41:53
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service...
April 11, 2018 at 11:08 am
Hello:
So, enabling the TLS 1.0 in the registry on the SQL Server 2014 Server solved my problem.
Thanks for your attempt to help me solve my issue, Perry Whittle.
April 11, 2018 at 9:22 am
Viewing 15 posts - 46 through 60 (of 101 total)