In last post, TIP#96 We have configured Database E-mail. Now in this post we will see how to send mail in SQL SERVER. Sometimes we need to send mail for different requirements like 1) Notification mails like data inserted /updated/deleted successfully 2)Send data reports like no of amount earned, failed transaction etc. for this …
Monthly Archives: April 2015
For different reason we need to send database report , data and other SQL Server database related stuff using E-mail . SQL Server provides E-mail functionality using “Database Email” feature. We can setup any E-mail in few simple steps. Let’s follow below steps Step 1:- Open “Management” option of object Explorer in SQL SERVER …
Although , It is out of box but I would like to share here. I am very choosy in food. When my mother/wife cooked food and I didn’t like the taste then I explicitly said I didn’t like but when food taste was awesome then I didn’t say a word. My mother taught me “You …
SET XACT_ABORT is one of the hidden gem we can say. It is helpful in many ways.Let me explain by an example suppose you are working on a stored procedure which is doing a complex data manipulation. You though this query will run with in 1 minute when you run it from .NET or other …