Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
CREATE TRIGGER Food.AlertRequest ON Food.RequestMaster AFTER INSERT AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for trigger here @squery = SELECT * from RequestMaster EXEC msdb.dbo.sp_send_dbmail @profile_name = DBMail, @recipients = 'email@example.com', @query = @squery, @subject = @message, @attach_query_result_as_file = 1 ; END GO
|SSIS how to COMPARE a data column from different servers?||6||79|
|Parsing the XML data to SQL Server||4||51|
|SQL Express connecting form remote error 26||7||34|
|Creating receive connector on exchnage 2013 for Oracle EBS not working||4||32|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!