How to send email through Sql Server 2008

Management >> Database Email >> Create profile and configure smtp Serevr or you can follow the given Link of Mr Pinaldave..

Step 1 : Create profile and configure smtp Serevr
 Step 2 :
sp_CONFIGURE 'show advanced', 1
GO
RECONFIGURE
GO
sp_CONFIGURE 'Database Mail XPs', 1
GO
RECONFIGURE
GO

Step 3:
USE YourDataBase
GO
EXEC sp_send_dbmail @profile_name='Your Profile',
@recipients='recipient email',
@subject='Test message',
@body='This is the body of the test message.
Congrates Database Mail Received By you Successfully.'

or Directly right click on Database Mail and you will get sending mail enterface.
 


Comments

Post a Comment

Popular posts from this blog

HOW TO Use the NumericUpDown Control

HOW TO Use the NumericUpDown Control  Great help taken from  http://www.asp.net/ajaxlibrary/HOW%20TO%20Use%20the%20NumericUpDown%20Control.ashx NumericUpDown Demonstration NumericUpDown Description NumericUpDown is an ASP.NET AJAX extender that can be attached to an ASP.NET TextBox control to add "up" and "down" buttons that increment and decrement the value in the TextBox. The increment and decrement can be simple +1/-1 arithmetic, they can cycle through a provided list of values (like the months of the year), or they can call a Web Service to determine the next value. Page authors can also provide custom images to be used instead of the default up/down button graphics. Video - How Do I: Use the ASP.NET AJAX NumericUpDown Control? NumericUpDown Client Code Sample view plain copy to clipboard print ? < script   runat = "server" >        [System.Web.Services.W...
Read more

How To Get IP & Locations details of client machine in asp.net

Using JQuery Add this code in head section <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>     <script type="text/javascript">         $.get("http://ipinfo.io/66.87.90.80", function (response) {             document.getElementById("<%=Label1.ClientID %>").innerHTML = "";             document.getElementById("<%=Label1.ClientID %>").innerHTML = "IP is : " + response.ip + "<br> Host Name is : " + response.hostname             + "<br> Host Name is : " + response.hostname             + "<br> City Name is : " + response.city             + "<br> Region Name is : " + response.region             + "<br> Country Name is : " + response.country   ...
Read more

Get control name in Page_Load event after post back by any control

Add script -------------------- function __doPostBack(eventTarget, eventArgument)  { if  (!theForm.onsubmit || (theForm.onsubmit() ! =   false )) { theForm.__EVENTTARGET.value  =  eventTarget; theForm.__EVENTARGUMENT.value  =  eventArgument; theForm.submit();  }  } ---------------------- <input type= "hidden"  name= "__EVENTTARGET"  id= "__EVENTTARGET"  value= ""  /> <input type= "hidden"  name= "__EVENTARGUMENT"  id= "__EVENTARGUMENT"  value= ""  /> <select name="DropDownList1" onchange="javascript:setTimeout('__doPostBack(\'DropDownList1\',\'\')', 0)" id="DropDownList1">             <option value="1">abc</option>             <option value="2">xyz</option> </select> --------------------- private string getPostBackControlName() ...
Read more