Activity overview
Latest activity by spthorn
Thanks, Dustin. Always a RedGate fan. / comments
Thanks, Dustin. Always a RedGate fan.
Sweet. Thanks for tracking this. / comments
Sweet. Thanks for tracking this.
GROUP BY suggestion incorrect for query containing FIRST_VALUE
CREATE TABLE #deleteme (
id INT
,value1 INT
)
SELECT
id
,FIRST_VALUE(id) OVER (ORDER by value1 DESC) AS foo
FROM #deleteme
GROUP BY FIRST_VALUE(id) OVER (ORDER BY value1 DESC), id -- what S...
Thanks for clarifying! I did think it odd, as the website/forums made no mention of it. Good deal. I love SQL Compare and use it on an at least weekly basis. / comments
Thanks for clarifying! I did think it odd, as the website/forums made no mention of it. Good deal. I love SQL Compare and use it on an at least weekly basis.
We got this email some minutes ago:
"As a SQL Comparison SDK customer, I’m writing to let you know that as of today we will no longer be offering any further updates or new licenses for this product.
Your current copy of SQL Comparison SDK will still work and you can keep using it for as long as you like. You will also receive full support for the duration of your existing license agreement.
Why we’re making this change
Our DLM Automation tool, available within the SQL Toolbelt, is a more efficient way of automating the SQL Server Deployment processes, and many customers have already switched over to this preferred method. In order to ensure sufficient resources and attention are available to develop our ingeniously simple range of SQL Server tools, we need to retire those products that no-longer meet the demands of our customers.
If you have any questions or concerns, simply reply to this email or contact our Support team.
Kind regards,
Leonardo Machado
Product Manager, Redgate" / comments
We got this email some minutes ago:
"As a SQL Comparison SDK customer, I’m writing to let you know that as of today we will no longer be offering any further updates or new licenses for this produc...
Super, Peter. Works great! Thanks to the redgate team for this patch! / comments
Super, Peter. Works great! Thanks to the redgate team for this patch!
Ok, Peter, I added that switch to the job via SSMS, and got the email generated as expected.
However, when I attempt to edit the job in SQLBackup, I get the error "Cannot Edit Job <snip> Unknown option: MAILLIB_SYN".
Overall, though, I'm happy I'm getting emails, and can deal with manual edits. Thanks so much for your help! / comments
Ok, Peter, I added that switch to the job via SSMS, and got the email generated as expected.
However, when I attempt to edit the job in SQLBackup, I get the error "Cannot Edit Job <snip> Unknown op...
Yes, it did generate the email just fine.
I went ahead and added email notification to one of my half-hourly transaction log backup jobs, just to see if that email would fail as well... and it did. Generated a SQL Backup warning "Warning 151: MAILTO error: Failed to send mail. (Must issue a STARTTLS command first)". / comments
Yes, it did generate the email just fine.
I went ahead and added email notification to one of my half-hourly transaction log backup jobs, just to see if that email would fail as well... and it did....
Yep, the Send Test Email button. / comments
Yep, the Send Test Email button.
Peter, I installed the patch files per your attached procedure. Still not getting emails.
SMTP Host: email-smtp.us-east-1.amazonaws.com
Results are the same regardless of SMTPEncoding value in registry (TLS, SSH or blank). Doesn't appear to be any change from before.
I tried the following ports (based on http://docs.aws.amazon.com/ses/latest/D ... nnect.html):
Port Result
465 Screen freezes, after 20 seconds or so it comes back, but no email received
2465 Screen freezes, after 20 seconds or so I get error "Socket Error # 10060 Connection timed out."
25 Screen freezes, after 20 seconds or so I get error "Socket Error # 10060 Connection timed out."
587 Get error "Must issue a STARTTLS command first"
2587 Screen freezes, after 20 seconds or so I get error "Socket Error # 10060 Connection timed out."
I don't doubt that it works with Gmail and Yahoo mail. Nobody else is using Amazon SES (Simple Email Service) with SQL Backup Pro? / comments
Peter, I installed the patch files per your attached procedure. Still not getting emails.
SMTP Host: email-smtp.us-east-1.amazonaws.com
Results are the same regardless of SMTPEncoding value in regi...