SQL Server Notification Services announcement
-
Link
The following forums can be used to post questions and discussion about the topics: SQLDependency/Query Notification and DBMail.
Please use http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads for SQLDependency and Query Notification.
Please use http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threads for DBMail.(Attribution: Jang-uk In)
Hope that helps,
-Lukasz
-
0 VotesUsing the stored procedure in sp_send_dbmail in sqlserver 2005
I have to generate a stored procedure to which will have an html attachment. Will the following link ...Answered | 1 Replies | 272 Views | Created by Avyayah - Wednesday, October 9, 2019 8:45 PM | Last reply by Olaf Helper - Thursday, October 10, 2019 6:33 AM
-
0 Votes
Mail sent from Sql Server database server 2008, with 2005 sqlserver to Helpdesk using ApexSQL
Does anyone know about ApexSql? Does it send Email? , We are sending an email to the helpdesk once a day that includes an HTML attachment? We have ...Answered | 1 Replies | 273 Views | Created by Avyayah - Tuesday, October 8, 2019 3:02 PM | Last reply by Olaf Helper - Wednesday, October 9, 2019 7:32 AM -
1 Votes
Space allocated in Temp drive
How much space is required in TempDB drive? Does it depend on the size of the datafile. Is there a formula I can use to calculate how much space I should allocate in TempDB drive?Answered | 2 Replies | 290 Views | Created by Avyayah - Tuesday, October 8, 2019 10:20 PM | Last reply by Jefferson Silva DBA - Wednesday, October 9, 2019 12:27 AM -
0 Votes
Cannot send mail to mail server
Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 4 (2019-09-20T09:06:15). Exception Message: Cannot send mails to ...Unanswered | 2 Replies | 429 Views | Created by Avyayah - Friday, September 20, 2019 3:05 PM | Last reply by Avyayah - Friday, September 20, 2019 4:37 PM -
0 Votes
MSSSPI-101: [LOG] Unable to read local eventlog (reason: The event log file has changed between read operations).
Hi all, I need help from your clever brains. I have problem with this issue: MSSSPI-101: [LOG] Unable to read local eventlog (reason: The event ... -
0 Votes
Detect SqlNotificationRequest failure in .Net?
Periodically SqlNotificationRequest fails to register a SQL query notification subscription (sys.dm_qn_subscriptions is an empty set). There doesn't appear to be a way to look up the UserData in ... -
0 Votes
Sending the user with Active Directory account the detailed error message
How do I send the user detailed error message from sqlserver job? This user has an ad account in sqlserver and Notification has her name. But she receives an email with summary only but not ... -
1 Votes
Database Mail Profile is not displayed when configuring Notification for a job.
I created a profile and account using the Database Mail wizard. I successfully sent and received a test email after setting it up. I then configured SQL Server Agent to use DB Mail and verified ...Answered | 7 Replies | 5055 Views | Created by FredHue - Wednesday, February 24, 2016 4:43 AM | Last reply by scott_morris-ga - Monday, April 29, 2019 3:57 PM -
1 Votes
Notification that a JOB did not start in SQL Server Agent
Is there a way to send an email alert notification when a job just didn't run? The job just didn't run so there is no failure or success.Proposed | 1 Replies | 1482 Views | Created by Charlie2 - Wednesday, April 17, 2019 2:37 PM | Last reply by Olaf Helper - Thursday, April 18, 2019 6:28 AM -
0 Votes
Unable to get SQLDependency to work as expected
Hi Folks, I have a simple console application (C#) for which I am trying to set up a notification system using SQLDependency. This issue is as soon ...Answered | 1 Replies | 1635 Views | Created by AndyW2007 - Thursday, March 14, 2019 2:09 AM | Last reply by AndyW2007 - Thursday, March 14, 2019 3:26 AM -
0 Votes
AlwayOn Monitoring via Alerts - Getting Lots of Emails
Hello, I have recently setup AlwaysOn in SQL Server 2017 and has been in Production for several weeks now. Everything is working fine. I'm currently ...Unanswered | 3 Replies | 1707 Views | Created by Sidney L - Tuesday, February 12, 2019 2:34 PM | Last reply by Mohsin_A_Khan - Tuesday, February 12, 2019 5:05 PM -
0 Votes
Two operators for one job
Hi, I have a SQL Server Agent job. If the job fails one email address must get a notifications. Not problem with that. But, another email address must get a ...Unanswered | 1 Replies | 1730 Views | Created by dktoa - Friday, February 1, 2019 1:53 PM | Last reply by Olaf Helper - Friday, February 1, 2019 2:06 PM -
0 Votes
SQL Timeout period elapsed error
Hello All, I have gotten an error today that has been going on since 8 AM this morning. The error is pointing to a timeout elapsed prior to completion of the operation or the server ...Unanswered | 1 Replies | 1976 Views | Created by Jeff at Frank - Wednesday, January 30, 2019 10:39 PM | Last reply by Olaf Helper - Thursday, January 31, 2019 7:34 AM -
0 Votes
Creating Automatic Robot or something like Crawler
My problem is that in Local SQL Server(2016, Not Asure), I have a table which people can request what type of house they want to buy. On the other hand, there's another table for different ...Unanswered | 1 Replies | 1923 Views | Created by Mohammad Amin(Iran) - Monday, December 24, 2018 11:35 AM | Last reply by ComputerScott - Thursday, December 27, 2018 8:28 PM -
0 Votes
Send an alert without SMTS server
Hello, We have few jobs configured for autogrowth, memory and cpu spike, blockage as per the client requirement. But, we don't have SMTP server so, we can't configure database ...Unanswered | 2 Replies | 1971 Views | Created by Chickoo79 - Wednesday, November 28, 2018 4:13 PM | Last reply by Visakh16 - Thursday, November 29, 2018 7:24 AM -
0 Votes
Send the email on the status of the SQL Server Performance
Hi Team, I need to send the report of each database and its performance at the end of the day. how to automate this?Unanswered | 1 Replies | 1960 Views | Created by Ideas12345 - Wednesday, November 21, 2018 12:52 AM | Last reply by Olaf Helper - Wednesday, November 21, 2018 7:08 AM -
0 Votes
SQL event logs wipes out after restart
Hi, Recently we had the issue where we could not connect to SQL server due to blocking. As we were not able to connect, we had to restart the SQL service. But as we restarted the ...Unanswered | 1 Replies | 2074 Views | Created by Kaps84 - Wednesday, October 24, 2018 9:22 AM | Last reply by ShabSQL - Wednesday, October 24, 2018 9:36 AM -
0 Votes
Alert message content with query result
Hi all, i set an alert to notify our team via mail in case of a mirror database state change. I set a WMI event alert with this query: SELECT * FROM ...Proposed | 5 Replies | 2080 Views | Created by DandiTV - Monday, October 22, 2018 9:16 AM | Last reply by DandiTV - Monday, October 22, 2018 1:48 PM -
0 Votes
Database Mail Error
We are recieving a bunch of database mail failed messages from a job that no longer exists. We had a job set up about a year ago to send blocking alerts but we disabled and deleted that job. ...Unanswered | 1 Replies | 2201 Views | Created by iojunta - Friday, September 21, 2018 5:45 PM | Last reply by Visakh16 - Friday, September 21, 2018 7:22 PM -
0 Votes
Office 365 and SQL reports: Failure sending mail: the remote certificate is invalid according to the validation procedure. mail will not be resent
Has anyone been able to get this to work? We recently migrated to office 365 from an onsite 2010 Exchange and the reports no longer ... - Items 1 to 20 of 855 Next ›
SQL Server Notification Services announcement
-
Link
The following forums can be used to post questions and discussion about the topics: SQLDependency/Query Notification and DBMail.
Please use http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads for SQLDependency and Query Notification.
Please use http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threads for DBMail.(Attribution: Jang-uk In)
Hope that helps,
-Lukasz
