{"id":55477,"date":"2023-12-07T07:44:42","date_gmt":"2023-12-07T07:44:42","guid":{"rendered":"https:\/\/dbtut.com\/?p=55477"},"modified":"2023-12-07T07:49:24","modified_gmt":"2023-12-07T07:49:24","slug":"how-to-send-telegram-messages-from-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/","title":{"rendered":"How To Send Telegram Messages From SQL Server"},"content":{"rendered":"<p>In today&#8217;s article, I will be explaining how to send the notifications we obtain while managing SQL Server to Telegram.<\/p>\n<p>First of all, of course, the first thing we need to do is to have a telegram account.<\/p>\n<p>I would also like to give basic information about Telegram.<\/p>\n<p>It is a WhatsApp-style messaging platform that we all use, and it has different features that distinguish both products from each other.<\/p>\n<p>We may need WhatsApp business or different middleware to send notifications from WhatsApp, which we will explain in the subject.<\/p>\n<p>After sharing information about Telegram, what we need to do is to obtain a token and a chat_id to send notifications in Telegram.<\/p>\n<p>To do this, we log in to &#8220;web.telegram.org&#8221;.<\/p>\n<figure style=\"width: 698px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.sqlekibi.com\/wp-content\/uploads\/2020\/04\/Resim-1.png\" alt=\"\" width=\"698\" height=\"506\" \/><figcaption class=\"wp-caption-text\">Picture-1 web.telegram.org<\/figcaption><\/figure>\n<p>We write @BotFather in the Search section and start the conversation with start.<\/p>\n<figure style=\"width: 693px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.sqlekibi.com\/wp-content\/uploads\/2020\/04\/Resim-2-BotFather.png\" alt=\"\" width=\"693\" height=\"969\" \/><figcaption class=\"wp-caption-text\">Picture-2 @BotFather features<\/figcaption><\/figure>\n<p>As seen in the picture above, we can actually get support for many contents with @BotFather.<\/p>\n<p>What we want to do is create a new bot.<\/p>\n<p>For this we write &#8220;\/newbot&#8221;.<\/p>\n<p>It first asks us for a name for the bot, and then a username for the bot.<\/p>\n<figure style=\"width: 696px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.sqlekibi.com\/wp-content\/uploads\/2020\/04\/Resim-3-Bot-Created.png\" alt=\"\" width=\"696\" height=\"991\" \/><figcaption class=\"wp-caption-text\">Picture-3 Bot Information<\/figcaption><\/figure>\n<p>The important thing to note in Picture 3 is that the username information must end with _bot, and the same picture gives you the HTTP API information you will need to use this bot. Don&#8217;t forget to take note of this information!<\/p>\n<p>Next is to get Chat_id information.<\/p>\n<p>To do this, we call the username we gave in picture-2 and say hello. (We search and find it and say start.)<\/p>\n<figure style=\"width: 932px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.sqlekibi.com\/wp-content\/uploads\/2020\/04\/Resim-4-hello-bot.png\" alt=\"\" width=\"932\" height=\"296\" \/><figcaption class=\"wp-caption-text\">Picture-4 Hello Bot<\/figcaption><\/figure>\n<p>After saying Hello to the bot we created, all we need to do is edit and open the address below in a new browser tab.<\/p>\n<pre class=\"lang:default decode:true \">https:\/\/api.telegram.org\/bot&lt;HTTPTOKENAPI&gt;\/getUpdates<\/pre>\n<p>Here we replace the part that says &lt;HTTPTOKENAPI&gt; with the HTTPAPI information we see in Picture 3.<\/p>\n<p>When we continue the process, a screen like the one below appears.<\/p>\n<figure style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.sqlekibi.com\/wp-content\/uploads\/2020\/04\/Resim-5-chat_id-1024x63.png\" alt=\"\" width=\"1024\" height=\"63\" \/><figcaption class=\"wp-caption-text\">Picture-5 Obtaining chat_id information<\/figcaption><\/figure>\n<p>We have completed what needs to be done on Telegram, now we have Token information and Chat_id information.<\/p>\n<p>Using these two information, we will make an http post request in SQL Server and send our notification.<\/p>\n<p>For this process, we first need to enable the use of Ole objects on the SQL Server side.<\/p>\n<p>Let&#8217;s do this with the code block below.<\/p>\n<pre class=\"lang:default decode:true \">EXEC sp_configure \u2018Ole Automation Procedures\u2019, 1;\r\nGO\r\nRECONFIGURE;\r\nGO<\/pre>\n<p>Now it&#8217;s time for the query to make the notification. There are two parts in the query that need to be changed.<\/p>\n<p>We will enter the Token and Chat_id information we have, write the notification we want and run the query. (You must fill in the @TelegramToken and @TelegramChatId information!)<\/p>\n<pre class=\"lang:default decode:true \">DECLARE @responseText NVARCHAR(2000);\r\nDECLARE @responseXML NVARCHAR(2000);\r\nDECLARE @ret INT;\r\nDECLARE @status NVARCHAR(32);\r\nDECLARE @statusText NVARCHAR(32);\r\nDECLARE @token INT;\r\nDECLARE @url NVARCHAR(256);\r\ndeclare @TelegramToken NVARCHAR(256);\r\ndeclare @TelegramChatId NVARCHAR(32)\r\ndeclare @TelegramMesaj  NVARCHAR(32)\r\n\r\nset @TelegramToken =\u201d\r\nset @TelegramChatId = \u201d\r\nset @TelegramMesaj = \u2018\u00c7a\u011flar \u00d6zen\u00e7 \u2013 DMC Bilgi Teknolojileri \u2018\r\n\r\nSET @url = \u2018https:\/\/api.telegram.org\/bot\u2019 + @TelegramToken +\u2019\/sendMessage?chat_id=\u2019+@TelegramChatId+\u2019&amp;parse_mode=Markdown&amp;text=CAGLAROZENCSQLServer-DMC\u2019;\r\n\r\n\u2014 Open the connection.\r\nEXEC @ret = sp_OACreate \u2018MSXML2.ServerXMLHTTP\u2019, @token OUT;\r\nIF @ret &lt;&gt; 0 RAISERROR(\u2018Unable to open HTTP connection.\u2019, 10, 1);\r\n\r\n\u2014 Send the request.\r\nEXEC @ret = sp_OAMethod @token, \u2018open\u2019, NULL, \u2018POST\u2019, @url, \u2018false\u2019;\r\nEXEC @ret = sp_OAMethod @token, \u2018setRequestHeader\u2019, NULL, \u2018Authentication\u2019, null;\r\nEXEC @ret = sp_OAMethod @token, \u2018setRequestHeader\u2019, NULL, \u2018Content-type\u2019, null;\r\nEXEC @ret = sp_OAMethod @token, \u2018send\u2019, NULL, null;\r\n\r\n\u2014 Handle the response.\r\nEXEC @ret = sp_OAGetProperty @token, \u2018status\u2019, @status OUT;\r\nEXEC @ret = sp_OAGetProperty @token, \u2018statusText\u2019, @statusText OUT;\r\nEXEC @ret = sp_OAGetProperty @token, \u2018responseText\u2019, @responseText OUT;\r\n\r\n\u2014 Show the response.\r\n\r\nPRINT \u2018Status: \u2018 + @status + \u2018 (\u2018 + @statusText + \u2018)\u2019;\r\nPRINT \u2018Response text: \u2018 + @responseText;\r\n\r\n\u2014 Close the connection.\r\nEXEC @ret = sp_OADestroy @token;\r\nIF @ret &lt;&gt; 0 RAISERROR(\u2018Unable to close HTTP connection.\u2019, 10, 1);<\/pre>\n<p>If your transaction is successful after the query, the information you provided will be sent to Telegram.<\/p>\n<figure style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.sqlekibi.com\/wp-content\/uploads\/2020\/04\/Resim-6-Sonuc-1024x385.png\" alt=\"\" width=\"1024\" height=\"385\" \/><figcaption class=\"wp-caption-text\">Picture6 Result<\/figcaption><\/figure>\n<p>By using this method, you can quickly get information about the developing situations in the SQL Server Database Servers under your management.<\/p>\n<p>With different improvements, you can send notifications to telegram groups and instantly inform many people other than yourself.<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_55477\" class=\"pvc_stats all  \" data-element-id=\"55477\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In today&#8217;s article, I will be explaining how to send the notifications we obtain while managing SQL Server to Telegram. First of all, of course, the first thing we need to do is to have a telegram account. I would also like to give basic information about Telegram. It is a WhatsApp-style messaging platform that &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_55477\" class=\"pvc_stats all  \" data-element-id=\"55477\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1414,"featured_media":55484,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-55477","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Send Telegram Messages From SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today&#039;s article, I will be explaining how to send the notifications we obtain while managing SQL Server to Telegram.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Send Telegram Messages From SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today&#039;s article, I will be explaining how to send the notifications we obtain while managing SQL Server to Telegram.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-07T07:44:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-07T07:49:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-07-104134.png\" \/>\n\t<meta property=\"og:image:width\" content=\"728\" \/>\n\t<meta property=\"og:image:height\" content=\"319\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"\u00c7a\u011flar \u00d6zen\u00e7\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u00c7a\u011flar \u00d6zen\u00e7\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/\"},\"author\":{\"name\":\"\u00c7a\u011flar \u00d6zen\u00e7\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab\"},\"headline\":\"How To Send Telegram Messages From SQL Server\",\"datePublished\":\"2023-12-07T07:44:42+00:00\",\"dateModified\":\"2023-12-07T07:49:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/\"},\"wordCount\":545,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-07-104134.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/\",\"name\":\"How To Send Telegram Messages From SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-07-104134.png\",\"datePublished\":\"2023-12-07T07:44:42+00:00\",\"dateModified\":\"2023-12-07T07:49:24+00:00\",\"description\":\"In today's article, I will be explaining how to send the notifications we obtain while managing SQL Server to Telegram.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-07-104134.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-07-104134.png\",\"width\":728,\"height\":319},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Send Telegram Messages From SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab\",\"name\":\"\u00c7a\u011flar \u00d6zen\u00e7\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g\",\"caption\":\"\u00c7a\u011flar \u00d6zen\u00e7\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/caglarozenc\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Send Telegram Messages From SQL Server - Database Tutorials","description":"In today's article, I will be explaining how to send the notifications we obtain while managing SQL Server to Telegram.","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:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How To Send Telegram Messages From SQL Server - Database Tutorials","og_description":"In today's article, I will be explaining how to send the notifications we obtain while managing SQL Server to Telegram.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2023-12-07T07:44:42+00:00","article_modified_time":"2023-12-07T07:49:24+00:00","og_image":[{"width":728,"height":319,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-07-104134.png","type":"image\/png"}],"author":"\u00c7a\u011flar \u00d6zen\u00e7","twitter_card":"summary_large_image","twitter_misc":{"Written by":"\u00c7a\u011flar \u00d6zen\u00e7","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/"},"author":{"name":"\u00c7a\u011flar \u00d6zen\u00e7","@id":"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab"},"headline":"How To Send Telegram Messages From SQL Server","datePublished":"2023-12-07T07:44:42+00:00","dateModified":"2023-12-07T07:49:24+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/"},"wordCount":545,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-07-104134.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/","name":"How To Send Telegram Messages From SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-07-104134.png","datePublished":"2023-12-07T07:44:42+00:00","dateModified":"2023-12-07T07:49:24+00:00","description":"In today's article, I will be explaining how to send the notifications we obtain while managing SQL Server to Telegram.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-07-104134.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/12\/Ekran-goruntusu-2023-12-07-104134.png","width":728,"height":319},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/12\/07\/how-to-send-telegram-messages-from-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Send Telegram Messages From SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/92baa6fd666fb707d903177fed07d6ab","name":"\u00c7a\u011flar \u00d6zen\u00e7","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/997658bc236de4f5a0f3f46e64535566e31ba96824c77c01165e863fc38fd1ba?s=96&d=mm&r=g","caption":"\u00c7a\u011flar \u00d6zen\u00e7"},"url":"https:\/\/dbtut.com\/index.php\/author\/caglarozenc\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1414"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=55477"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55477\/revisions"}],"predecessor-version":[{"id":55485,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55477\/revisions\/55485"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/55484"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=55477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=55477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=55477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}