Skip to main content

Configure Database Mail - Send Email From SQL Database

http://www.codeproject.com/Articles/29060/SQL-SERVER-2008-Configure-Database-Mail-Send-Email

1. create profile
2.  configure email
     run this code for configure
    sp_CONFIGURE 'show advanced', 1
   GO
   RECONFIGURE
   GO
   sp_CONFIGURE 'Database Mail XPs', 1
   GO
   RECONFIGURE
   GO
3. Send mail

EXEC sp_send_dbmail @profile_name='Test',
@recipients='test@example.com',
@subject='Test message',
@body='This is the body of the test message. sent through DataBase mail'

Comments

Post a Comment

Popular posts from this blog

Types Of Join In SQL

Sql joins are used to fetch/retrieve data from two or more data tables, based on a join condition. A join condition is a relationship among some columns in the data tables that take part in Sql join. Basically data tables are related to each other with keys. We use these keys relationship in sql joins. Inner Join Outer Join Cross Join Cross Join
Post a Comment
Read more

Change Key Dynamically in Web.Config

System.Xml; private void SetConfigSettings() { string path = Server.MapPath("Web.config"); string newConnectionString = @"Server=local;Database="+txtDatabaseName.Text+";Trusted_Connection=true"; XmlDocument xDoc = new XmlDocument(); xDoc.Load(path); XmlNodeList nodeList = xDoc.GetElementsByTagName("appSettings"); XmlNodeList nodeAppSettings = nodeList[0].ChildNodes; XmlAttributeCollection xmlAttCollection = nodeAppSettings[0].Attributes; xmlAttCollection[0].InnerXml = txtKey.Text; // for key attribute xmlAttCollection[1].InnerXml = newConnectionString; // for value attribute xDoc.Save(path); // saves the web.config file }
Post a Comment
Read more