{"id":2875,"date":"2021-09-16T15:25:42","date_gmt":"2021-09-16T12:25:42","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=2875"},"modified":"2023-05-16T22:03:47","modified_gmt":"2023-05-16T19:03:47","slug":"pos-stelnoyme-email-mesa-apo-ton-sql-server","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/","title":{"rendered":"How we send email through SQL Server"},"content":{"rendered":"<p>Through Microsoft SQL Server we have the possibility to send emails either for some alerting or so that we can send reports. <\/p>\n\n\n\n<p>In this article we will see step by step how it works and how to activate it <strong>Database Mail <\/strong>in SQL Server. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"267\" height=\"455\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-08.gif\" alt=\"\" class=\"wp-image-2902\"\/><figcaption class=\"wp-element-caption\">01 (docs.microsoft.com) <\/figcaption><\/figure>\n<\/div>\n\n\n<p>When a user executes the system procedure <strong>msdb.dbo.sp_send_dbmail<\/strong>  with the email it wants to send, SQL Server forwards it to the SMTP mail server of the respective provider such as outlook, exchange, gmail and then sends it to the end user. This process can be activated either <em>adhoc <\/em>whenever we call the procedure, either through a schedule in the SQL Server Agent, or by creating alerting <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/agent\/operators?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Operators<\/a> in the SQL Server Agent. <\/p>\n\n\n\n<p>Let&#039;s see now the steps we will have to follow and the settings we will have to make in order to have this possibility.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The example<\/h2>\n\n\n\n<p>For the beginning the example I will use one<em> <\/em>account at <em>gmail <\/em>. gmail to allow access from SQL Server we should have gone to its page and enabled allow access to less secure applications from <a href=\"https:\/\/myaccount.google.com\/lesssecureapps\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a> .<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"801\" height=\"434\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-06.png\" alt=\"\" class=\"wp-image-2881\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-06.png 801w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-06-300x163.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-06-768x416.png 768w\" sizes=\"auto, (max-width: 801px) 100vw, 801px\" \/><figcaption class=\"wp-element-caption\">02<\/figcaption><\/figure>\n\n\n\n<p>We choose below <strong>instance <\/strong>us, <strong>Management<\/strong>, <strong>Database<\/strong> <strong>Mail<\/strong>, right click <strong>Configure Database Mail<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"336\" height=\"536\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-01.png\" alt=\"\" class=\"wp-image-2876\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-01.png 336w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-01-188x300.png 188w\" sizes=\"auto, (max-width: 336px) 100vw, 336px\" \/><figcaption class=\"wp-element-caption\">03<\/figcaption><\/figure>\n\n\n\n<p>Then we select it<strong> Setup<\/strong> since we want to create a new Mail Database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"711\" height=\"562\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-02.png\" alt=\"\" class=\"wp-image-2877\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-02.png 711w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-02-300x237.png 300w\" sizes=\"auto, (max-width: 711px) 100vw, 711px\" \/><figcaption class=\"wp-element-caption\">04<\/figcaption><\/figure>\n\n\n\n<p>It will then ask us to give a name to the <strong>Profile<\/strong> us and we choose <strong>Add<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"719\" height=\"569\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-03.png\" alt=\"\" class=\"wp-image-2878\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-03.png 719w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-03-300x237.png 300w\" sizes=\"auto, (max-width: 719px) 100vw, 719px\" \/><figcaption class=\"wp-element-caption\">05<\/figcaption><\/figure>\n\n\n\n<p>At this point we should fill in all the details of the SMTP provider such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The e-mail address<\/li>\n\n\n\n<li>The name that will appear as the sender<\/li>\n\n\n\n<li>The name of the SMTP server, in our case is o <strong>smtp.gmail.com<\/strong> who listens at the door <strong>587<\/strong><\/li>\n\n\n\n<li>We choose SSL secure connection (required for gmail)<\/li>\n\n\n\n<li>And in basic authentication, our gmail credentials<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"722\" height=\"573\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-04.png\" alt=\"\" class=\"wp-image-2879\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-04.png 722w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-04-300x238.png 300w\" sizes=\"auto, (max-width: 722px) 100vw, 722px\" \/><figcaption class=\"wp-element-caption\">06<\/figcaption><\/figure>\n\n\n\n<p>In the next step we select it as public and default so that anyone can use it.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"722\" height=\"573\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-05.png\" alt=\"\" class=\"wp-image-2880\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-05.png 722w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-05-300x238.png 300w\" sizes=\"auto, (max-width: 722px) 100vw, 722px\" \/><figcaption class=\"wp-element-caption\">07<\/figcaption><\/figure>\n\n\n\n<p>At the finish it asks to send a test email to any address we prefer. I wrote my personal gmail and immediately received the following:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"582\" height=\"398\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-07.png\" alt=\"\" class=\"wp-image-2882\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-07.png 582w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/emsq-07-300x205.png 300w\" sizes=\"auto, (max-width: 582px) 100vw, 582px\" \/><figcaption class=\"wp-element-caption\">08<\/figcaption><\/figure>\n\n\n\n<p>Alternatively, we can do the whole process above with T-SQL with the following code:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">DECLARE @profile_name sysname,\n        @account_name sysname,\n        @SMTP_servername sysname,\n        @email_address NVARCHAR(128),\n\t    @display_name NVARCHAR(128),\n\t\t@username nvarchar(128),\n\t\t@password nvarchar(128),\n\t\t@enable_ssl int,\n\t\t@port INT;\n\n        SET @profile_name = 'gmail';\n\t\tSET @account_name = 'gmail';\n\t\tSET @SMTP_servername = 'smtp.gmail.com';\n\t\tSET @port = 587 --default 25\n\t\tSET @enable_ssl = 1\n\t\tSET @email_address = 'dataplatform.gr@gmail.com';\n        SET @display_name = 'info@dataplatform.gr';\n\t\tSET @username = 'dataplatform.gr@gmail.com';\n\t\tSET @password= 'password';\n\n\nIF EXISTS (SELECT * FROM msdb.dbo.sysmail_profile WHERE name = @profile_name)\nBEGIN\n  RAISERROR('The specified Database Mail profile (gmail) already exists.', 16, 1);\n  GOTO done;\nEND;\n\nIF EXISTS (SELECT * FROM msdb.dbo.sysmail_account WHERE name = @account_name )\nBEGIN\n RAISERROR('The specified Database Mail account (gmail) already exists.', 16, 1) ;\n GOTO done;\nEND;\n\nBEGIN TRANSACTION ;\n\nDECLARE @rv INT;\n\nEXECUTE @rv=msdb.dbo.sysmail_add_account_sp\n    @account_name = @account_name,\n    @email_address = @email_address,\n    @display_name = @display_name,\n    @mailserver_name = @SMTP_servername,\n\t@username=@username,\n\t@password=@password,\n\t@enable_ssl=@enable_ssl,\n\t@port=@port;\n\t\n\nIF @rv&lt;>0\nBEGIN\n    RAISERROR('Failed to create the specified Database Mail account (gmail).', 16, 1) ;\n    GOTO done;\nEND\n\nEXECUTE @rv=msdb.dbo.sysmail_add_profile_sp\n    @profile_name = @profile_name ;\n\nIF @rv&lt;>0\nBEGIN\n    RAISERROR('Failed to create the specified Database Mail profile (gmail).', 16, 1);\n\tROLLBACK TRANSACTION;\n    GOTO done;\nEND;\n\nEXECUTE @rv=msdb.dbo.sysmail_add_profileaccount_sp\n    @profile_name = @profile_name,\n    @account_name = @account_name,\n    @sequence_number = 1 ;\n\nIF @rv&lt;>0\nBEGIN\n    RAISERROR('Failed to associate the specified profile with the specified account (gmail).', 16, 1) ;\n\tROLLBACK TRANSACTION;\n    GOTO done;\nEND;\n\nCOMMIT TRANSACTION;\n\ndone:\n\nGO\n\nsp_configure \"show advanced options\",1\ngo\nsp_configure \"Database Mail XPs\",1\ngo\nreconfigure\ngo\nsp_configure \"show advanced options\",0\ngo\n\nUSE [msdb]\nGO\nEXEC msdb.dbo.sp_set_sqlagent_properties @email_save_in_sent_folder=1, \n\t\t@databasemail_profile=N'gmail', \n\t\t@use_databasemail=1\nGO\n<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">After Database Mail is installed how do we send new On Demand?<\/h2>\n\n\n\n<p>As we mentioned at the beginning with the use of the systemic procedure <strong>msdb.dbo.sp_send_dbmail<\/strong> we can send email.<\/p>\n\n\n\n<p>The parameters needed are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The profile_name we made during setup<\/li>\n\n\n\n<li>The emails that will be sent<\/li>\n\n\n\n<li>The title of the email<\/li>\n\n\n\n<li>And the text of the email<\/li>\n\n\n\n<li>We also have the option to add file_attachments (provided, of course, that the account that launches the service has the right to see the files)<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">EXEC msdb.dbo.sp_send_dbmail  \n@profile_name = 'gmail',  \n@recipients = 'info@dataplatform.gr', \n--@file_attachments = 'C:\\file.txt', \n@subject = 'Titlos',  \n@body = 'Keimeno';\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">How can we see the progress of sending emails<\/h2>\n\n\n\n<p>With the following queries we can see respectively:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Which emails were sent successfully?<\/li>\n\n\n\n<li>Which is in the process of shipping<\/li>\n\n\n\n<li>And in which their mission failed<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">select * from msdb.dbo.sysmail_sentitems;\nselect * from msdb.dbo.sysmail_unsentitems;\nselect * from msdb.dbo.sysmail_faileditems;<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Sources:<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/database-mail\/database-mail?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Database Mail<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Through Microsoft SQL Server we have the possibility to send emails either for some alerting or so that we can send reports. In this article we will see step by step how it works and how we activate Database Mail in SQL Server. When a user runs the msdb.dbo.sp_send_dbmail system procedure with the email they want [\u2026]<\/p>","protected":false},"author":1,"featured_media":702,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,11,15],"tags":[134,29,23,30,155,6],"class_list":["post-2875","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","category-databases","category-ms-sqlserver","tag-alerting","tag-databases","tag-microsoft","tag-rdbms","tag-reporting","tag-sqlserver"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u03a0\u03ce\u03c2 \u03c3\u03c4\u03ad\u03bb\u03bd\u03bf\u03c5\u03bc\u03b5 email \u03bc\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd SQL Server - DataPlatform.gr<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dataplatform.gr\/en\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u03a0\u03ce\u03c2 \u03c3\u03c4\u03ad\u03bb\u03bd\u03bf\u03c5\u03bc\u03b5 email \u03bc\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd SQL Server - DataPlatform.gr\" \/>\n<meta property=\"og:description\" content=\"\u039c\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd Microsoft SQL Server \u03ad\u03c7\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7 \u03b4\u03c5\u03bd\u03b1\u03c4\u03cc\u03c4\u03b7\u03c4\u03b1 \u03bd\u03b1 \u03c3\u03c4\u03ad\u03bb\u03bd\u03bf\u03c5\u03bc\u03b5 email \u03b5\u03af\u03c4\u03b5 \u03b3\u03b9\u03b1 \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf alerting \u03b5\u03af\u03c4\u03b5 \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03c3\u03c4\u03ad\u03bb\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b1\u03bd\u03b1\u03c6\u03bf\u03c1\u03ad\u03c2. \u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03b2\u03ae\u03bc\u03b1 \u03b2\u03ae\u03bc\u03b1 \u03c0\u03c9\u03c2 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03b5\u03af \u03ba\u03b1\u03b9 \u03c0\u03c9\u03c2 \u03b5\u03bd\u03b5\u03c1\u03b3\u03bf\u03c0\u03bf\u03b9\u03bf\u03cd\u03bc\u03b5 to Database Mail \u03c3\u03c4\u03bf\u03bd SQL Server. \u038c\u03c4\u03b1\u03bd \u03ad\u03bd\u03b1\u03c2 \u03c7\u03c1\u03ae\u03c3\u03c4\u03b7\u03c2 \u03b5\u03ba\u03c4\u03b5\u03bb\u03b5\u03af \u03c4\u03b7\u03bd \u03c3\u03c5\u03c3\u03c4\u03b7\u03bc\u03b9\u03ba\u03ae procedure msdb.dbo.sp_send_dbmail \u03bc\u03b5 \u03c4\u03bf email \u03c0\u03bf\u03c5 \u03b8\u03ad\u03bb\u03b5\u03b9 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dataplatform.gr\/en\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"DataPlatform.gr\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dataplatform.gr\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-16T12:25:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-16T19:03:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Stratos Matzouranis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stratos Matzouranis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-stelnoyme-email-mesa-apo-ton-sql-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-stelnoyme-email-mesa-apo-ton-sql-server\\\/\"},\"author\":{\"name\":\"Stratos Matzouranis\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\"},\"headline\":\"\u03a0\u03ce\u03c2 \u03c3\u03c4\u03ad\u03bb\u03bd\u03bf\u03c5\u03bc\u03b5 email \u03bc\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd SQL Server\",\"datePublished\":\"2021-09-16T12:25:42+00:00\",\"dateModified\":\"2023-05-16T19:03:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-stelnoyme-email-mesa-apo-ton-sql-server\\\/\"},\"wordCount\":106,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-stelnoyme-email-mesa-apo-ton-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"keywords\":[\"Alerting\",\"Databases\",\"Microsoft\",\"RDBMS\",\"Reporting\",\"SQL Server\"],\"articleSection\":[\"Business Intelligence\",\"Databases\",\"Microsoft SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-stelnoyme-email-mesa-apo-ton-sql-server\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-stelnoyme-email-mesa-apo-ton-sql-server\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-stelnoyme-email-mesa-apo-ton-sql-server\\\/\",\"name\":\"\u03a0\u03ce\u03c2 \u03c3\u03c4\u03ad\u03bb\u03bd\u03bf\u03c5\u03bc\u03b5 email \u03bc\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd SQL Server - DataPlatform.gr\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-stelnoyme-email-mesa-apo-ton-sql-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-stelnoyme-email-mesa-apo-ton-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"datePublished\":\"2021-09-16T12:25:42+00:00\",\"dateModified\":\"2023-05-16T19:03:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-stelnoyme-email-mesa-apo-ton-sql-server\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-stelnoyme-email-mesa-apo-ton-sql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-stelnoyme-email-mesa-apo-ton-sql-server\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-stelnoyme-email-mesa-apo-ton-sql-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft SQL Server\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/ms-sqlserver\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"\u03a0\u03ce\u03c2 \u03c3\u03c4\u03ad\u03bb\u03bd\u03bf\u03c5\u03bc\u03b5 email \u03bc\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"name\":\"dataplatform.gr - Sky is not the limit!\",\"description\":\"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dataplatform.gr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\",\"name\":\"dataplatform.gr\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"width\":322,\"height\":139,\"caption\":\"dataplatform.gr\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dataplatform.gr\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dataplatform-gr\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\",\"name\":\"Stratos Matzouranis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"caption\":\"Stratos Matzouranis\"},\"sameAs\":[\"https:\\\/\\\/www.dataplatform.gr\"],\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/en\\\/author\\\/stratos-matzouranis\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u03a0\u03ce\u03c2 \u03c3\u03c4\u03ad\u03bb\u03bd\u03bf\u03c5\u03bc\u03b5 email \u03bc\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd SQL Server - DataPlatform.gr","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dataplatform.gr\/en\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"\u03a0\u03ce\u03c2 \u03c3\u03c4\u03ad\u03bb\u03bd\u03bf\u03c5\u03bc\u03b5 email \u03bc\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd SQL Server - DataPlatform.gr","og_description":"\u039c\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd Microsoft SQL Server \u03ad\u03c7\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7 \u03b4\u03c5\u03bd\u03b1\u03c4\u03cc\u03c4\u03b7\u03c4\u03b1 \u03bd\u03b1 \u03c3\u03c4\u03ad\u03bb\u03bd\u03bf\u03c5\u03bc\u03b5 email \u03b5\u03af\u03c4\u03b5 \u03b3\u03b9\u03b1 \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf alerting \u03b5\u03af\u03c4\u03b5 \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03c3\u03c4\u03ad\u03bb\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b1\u03bd\u03b1\u03c6\u03bf\u03c1\u03ad\u03c2. \u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03b2\u03ae\u03bc\u03b1 \u03b2\u03ae\u03bc\u03b1 \u03c0\u03c9\u03c2 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03b5\u03af \u03ba\u03b1\u03b9 \u03c0\u03c9\u03c2 \u03b5\u03bd\u03b5\u03c1\u03b3\u03bf\u03c0\u03bf\u03b9\u03bf\u03cd\u03bc\u03b5 to Database Mail \u03c3\u03c4\u03bf\u03bd SQL Server. \u038c\u03c4\u03b1\u03bd \u03ad\u03bd\u03b1\u03c2 \u03c7\u03c1\u03ae\u03c3\u03c4\u03b7\u03c2 \u03b5\u03ba\u03c4\u03b5\u03bb\u03b5\u03af \u03c4\u03b7\u03bd \u03c3\u03c5\u03c3\u03c4\u03b7\u03bc\u03b9\u03ba\u03ae procedure msdb.dbo.sp_send_dbmail \u03bc\u03b5 \u03c4\u03bf email \u03c0\u03bf\u03c5 \u03b8\u03ad\u03bb\u03b5\u03b9 [&hellip;]","og_url":"https:\/\/www.dataplatform.gr\/en\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/","og_site_name":"DataPlatform.gr","article_publisher":"https:\/\/www.facebook.com\/dataplatform.gr\/","article_published_time":"2021-09-16T12:25:42+00:00","article_modified_time":"2023-05-16T19:03:47+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","type":"image\/png"}],"author":"Stratos Matzouranis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stratos Matzouranis","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dataplatform.gr\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/"},"author":{"name":"Stratos Matzouranis","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf"},"headline":"\u03a0\u03ce\u03c2 \u03c3\u03c4\u03ad\u03bb\u03bd\u03bf\u03c5\u03bc\u03b5 email \u03bc\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd SQL Server","datePublished":"2021-09-16T12:25:42+00:00","dateModified":"2023-05-16T19:03:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/"},"wordCount":106,"commentCount":0,"publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","keywords":["Alerting","Databases","Microsoft","RDBMS","Reporting","SQL Server"],"articleSection":["Business Intelligence","Databases","Microsoft SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dataplatform.gr\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dataplatform.gr\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/","url":"https:\/\/www.dataplatform.gr\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/","name":"\u03a0\u03ce\u03c2 \u03c3\u03c4\u03ad\u03bb\u03bd\u03bf\u03c5\u03bc\u03b5 email \u03bc\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd SQL Server - DataPlatform.gr","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","datePublished":"2021-09-16T12:25:42+00:00","dateModified":"2023-05-16T19:03:47+00:00","breadcrumb":{"@id":"https:\/\/www.dataplatform.gr\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dataplatform.gr\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/#primaryimage","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.dataplatform.gr\/pos-stelnoyme-email-mesa-apo-ton-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae","item":"https:\/\/www.dataplatform.gr\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/www.dataplatform.gr\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Microsoft SQL Server","item":"https:\/\/www.dataplatform.gr\/category\/databases\/ms-sqlserver\/"},{"@type":"ListItem","position":4,"name":"\u03a0\u03ce\u03c2 \u03c3\u03c4\u03ad\u03bb\u03bd\u03bf\u03c5\u03bc\u03b5 email \u03bc\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.dataplatform.gr\/#website","url":"https:\/\/www.dataplatform.gr\/","name":"dataplatform.gr - Sky is not the limit!","description":"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.","publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dataplatform.gr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dataplatform.gr\/#organization","name":"dataplatform.gr","url":"https:\/\/www.dataplatform.gr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","width":322,"height":139,"caption":"dataplatform.gr"},"image":{"@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dataplatform.gr\/","https:\/\/www.linkedin.com\/company\/dataplatform-gr\/"]},{"@type":"Person","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf","name":"Stratos Matzouranis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","caption":"Stratos Matzouranis"},"sameAs":["https:\/\/www.dataplatform.gr"],"url":"https:\/\/www.dataplatform.gr\/en\/author\/stratos-matzouranis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/2875","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/comments?post=2875"}],"version-history":[{"count":1,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/2875\/revisions"}],"predecessor-version":[{"id":5460,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/2875\/revisions\/5460"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media\/702"}],"wp:attachment":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media?parent=2875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/categories?post=2875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/tags?post=2875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}