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 VotesMicrosoft SQL Server - SQL Server Agent with scheduled email using the - msdb.dbo.sp_send_dbmail - stored procedure truncates body of email
I have the below T-SQL script in SQL Server Agent, and it is scheduled to run at 7 AM and 7 PM everyday. DECLARE @Report_output nvarchar(4000); DECLARE ...Unanswered | 5 Replies | 371 Views | Created by sph1777 - Thursday, December 19, 2019 8:02 PM | Last reply by sph1777 - Tuesday, December 24, 2019 4:11 AM
-
0 Votes
Send email via SQL Server Agent, based on the result of a T-SQL stored procedure
12, I will need to send a email 2) If HourDifferenceCapturedUnanswered | 1 Replies | 388 Views | Created by sph1777 - Monday, December 9, 2019 9:00 PM | Last reply by Vaibhav-Chaudhari - Tuesday, December 10, 2019 7:33 AM -
0 Votes
Sql server Always ON set up on Windows Failover Clustering
We have currently SQL Server 2016 (SP2-CU6) (X64) Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Hypervisor) and we are planning to create another ... -
0 Votes
System.IO.FileNotFoundException occured in SQLPS.exe [4832]
I'm getting a System.IO.FileNotFoundException error on SQL Server 2008 which is running on Windows Server 2008. I keep getting these exeptions every evening while the SQL Server is trying to perform a ...Unanswered | 3 Replies | 19166 Views | Created by Abiral - Thursday, May 5, 2011 1:58 PM | Last reply by Steven Kirchner - Tuesday, November 26, 2019 6:42 PM -
0 Votes
Using 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 | 779 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 | 784 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 | 882 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 | 1223 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 | 5619 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 | 2149 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 | 2198 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 | 2373 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 | 2456 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 | 2601 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 | 2389 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 | 2477 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 | 2566 Views | Created by Ideas12345 - Wednesday, November 21, 2018 12:52 AM | Last reply by Olaf Helper - Wednesday, November 21, 2018 7:08 AM - Items 1 to 20 of 858 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
