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
Found 865 threads
-
0 Votessp_send_dbmail - Getting error for permissions
I am beating my head against a wall, I am trying to set up a job to run and produce an xls to send to certain members. If I take the "--" away from "Use ...
-
0 Votes
How to update a web page based on changes in database without using SQLTableDependency in Azure
As there are no low cost option but to use Azure SQL Managed Instances when I need to update a web page in real time, is there any other feature or function to use for a simple task like this that ... -
0 Votes
How to delete email address from sysmail_mailitems
sysmail_mailitems has reference of an email address in SQLserver. How can the email address be deleted? How do I delete one of the recipients email ...Answered | 2 Replies | 3269 Views | Created by Avyayah - Monday, April 13, 2020 8:17 PM | Last reply by AV111 - Wednesday, May 27, 2020 6:39 AM -
0 Votes
SQL errors
Hi We have a 2 Node SQL 2016 AG with a single DB. Now I am looking for an script or query that can be run once a day and check the SQL errors for the errors with severity ...Unanswered | 11 Replies | 3162 Views | Created by Shahin - Thursday, March 5, 2020 9:35 AM | Last reply by Shanky_621 - Wednesday, April 8, 2020 1:12 PM -
0 Votes
SQL Server Database Mail
I have a Win Server 2003, running SQL Server 2005. I wanted to configure email sending in SQL Server (Database Mail) using O365 with the following parameter: - ...Unanswered | 7 Replies | 3820 Views | Created by VCFab - Thursday, March 5, 2020 1:48 PM | Last reply by VCFab - Friday, March 6, 2020 5:36 PM -
0 Votes
Mail Profiler Issue in Sql Job
In sql job the step is to notify the operator with the below code. Sometimes the job fails and it takes few hrs to correct the error automatically not sure ...Unanswered | 1 Replies | 2923 Views | Created by Avyayah - Tuesday, February 25, 2020 4:25 PM | Last reply by Olaf Helper - Wednesday, February 26, 2020 9:43 AM -
0 Votes
SQL Server Agent - Error "Executed as user: DomainName\UserName. Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login failed for user 'DomainName\UserName'.. Process Exit Code 1. The step failed."
I have set up a step in SQL Server Agent with the following code sqlcmd -S ServerName\InstanceName -E -Q "backup database LJC to disk ...Answered | 4 Replies | 3357 Views | Created by lcerni - Thursday, February 6, 2020 5:22 PM | Last reply by lcerni - Friday, February 7, 2020 6:08 PM -
0 Votes
sqldependency , Sql server 2017 express
Does sqldependency works with express edition of sql server 2017 ? On the internet they say it works , but work for me with sql 2019 entreprise and ...Answered | 2 Replies | 3339 Views | Created by G13Z_AL - Monday, January 6, 2020 1:54 PM | Last reply by G13Z_AL - Monday, January 6, 2020 2:28 PM -
0 Votes
Microsoft 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 | 3925 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 | 3681 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 | 22544 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 | 4055 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 | 4081 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 | 4454 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 | 4497 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 | 9826 Views | Created by FredHue - Wednesday, February 24, 2016 4:43 AM | Last reply by scott_morris-ga - Monday, April 29, 2019 3:57 PM - Items 1 to 20 of 865 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
