{"id":533,"date":"2013-09-03T11:29:34","date_gmt":"2013-09-03T11:29:34","guid":{"rendered":"http:\/\/ntspl.co.in\/blog\/?p=533"},"modified":"2021-12-20T11:03:52","modified_gmt":"2021-12-20T11:03:52","slug":"database-mail-in-sql","status":"publish","type":"post","link":"https:\/\/www.ntspl.co.in\/blog\/database-mail-in-sql\/","title":{"rendered":"Database mail in sql"},"content":{"rendered":"<p>Generally we configure mail in fronted (Asp.net). Now you can also configure mail using SQL (In enterprise version) .<\/p>\n<dl class=\"data-inline\">\n<dt>Step 1:<\/dt>\n<dd>Connect the SQL<\/dd>\n<dt>Step 2:<\/dt>\n<dd>Right click on <strong>Database mail<\/strong> &amp; click on <strong>Configure Database Mail<\/strong><\/dd>\n<dt>Step 3:<\/dt>\n<dd>Then you will get &#8220;<strong>Configure Database Mail wizard<\/strong>&#8220;. &amp; click on Next<\/dd>\n<dt>Step 4:<\/dt>\n<dd>Then you will get &#8220;<strong>Select configuration task<\/strong>&#8221; &amp; choose &#8220;<strong>Setup database mail by performing following task<\/strong>&#8221; \u00a0<strong>\u00a0(<\/strong>http:\/\/prntscr.com\/1ohdkd<strong>)<\/strong><\/dd>\n<dt>Step 5:<\/dt>\n<dd>Then you will get &#8220;<strong>Select configuration task<\/strong>&#8221; &amp; create a \u00a0<strong>Profile<\/strong> with <strong>SMTP account<\/strong> by click on <strong>Add<\/strong> button\u00a0(http:\/\/prntscr.com\/1ohdmj)<\/dd>\n<dt>Step 6:<\/dt>\n<dd>Then you will get &#8220;<strong>New database Mail Account<\/strong>&#8221; wizard &amp; create a \u00a0<strong>Profile<\/strong>\u00a0with\u00a0<strong>SMTP account<\/strong>\u00a0by click on\u00a0<strong>Add<\/strong>\u00a0button (http:\/\/prntscr.com\/1ohdqj)<\/dd>\n<dt>Step 7:<\/dt>\n<dd>Fill the all required fields.(http:\/\/prntscr.com\/1ohdb5)<\/dd>\n<dt>Step 8:<\/dt>\n<dd>Click Finish &amp; Send a Test mail using sql (http:\/\/prntscr.com\/1ohdya)<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"<p>Generally we configure mail in fronted (Asp.net). Now you can also configure mail using SQL (In enterprise version) . Step 1: Connect the SQL Step 2: Right click on Database mail &amp; click on Configure Database Mail Step 3: Then you will get &#8220;Configure Database Mail wizard&#8220;. &amp; click on Next Step 4: Then you [&hellip;]<\/p>\n","protected":false},"author":18,"featured_media":1492,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[30],"tags":[115],"class_list":["post-533","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","tag-database-mail"],"acf":{"custom_meta_title":"Send Database Mail Using SQL | NTSPL","meta_description":"Do you know, now you can also send database mail in SQL. Get to Know how to send database mails using SQL. Read the step by step article.","meta_keyword":"database mail using sql, configure mail using sql","other_meta_tag":"<meta property=og:locale content=\"en-IN\" \/>\r\n<meta property=og:type content=\"website\" \/>\r\n<meta property=og:title content=\"Send Database Mail Using SQL | NTSPL\"\/>\r\n<meta property=og:description content=\"Do you know, now you can also send database mail in SQL. Get to Know how to send database mails using SQL. Read the step by step article.\"\/>\r\n<meta property=og:url content=\"https:\/\/www.ntspl.co.in\/blog\/database-mail-in-sql\"\/>\r\n<meta property=og:site_name content=NTSPL \/>\r\n<meta name=\"twitter:site\" content=\"@NTSPL\">\r\n<meta name=twitter:card content=\"summary\" \/>\r\n<meta name=twitter:description content=\"Do you know, now you can also send database mail in SQL. Get to Know how to send database mails using SQL. Read the step by step article.\"\/>\r\n<meta name=twitter:title content=\"Send Database Mail Using SQL | NTSPL\"\/>"},"_links":{"self":[{"href":"https:\/\/www.ntspl.co.in\/blog\/wp-json\/wp\/v2\/posts\/533"}],"collection":[{"href":"https:\/\/www.ntspl.co.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ntspl.co.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ntspl.co.in\/blog\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ntspl.co.in\/blog\/wp-json\/wp\/v2\/comments?post=533"}],"version-history":[{"count":6,"href":"https:\/\/www.ntspl.co.in\/blog\/wp-json\/wp\/v2\/posts\/533\/revisions"}],"predecessor-version":[{"id":4364,"href":"https:\/\/www.ntspl.co.in\/blog\/wp-json\/wp\/v2\/posts\/533\/revisions\/4364"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ntspl.co.in\/blog\/wp-json\/wp\/v2\/media\/1492"}],"wp:attachment":[{"href":"https:\/\/www.ntspl.co.in\/blog\/wp-json\/wp\/v2\/media?parent=533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ntspl.co.in\/blog\/wp-json\/wp\/v2\/categories?post=533"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ntspl.co.in\/blog\/wp-json\/wp\/v2\/tags?post=533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}