{"id":1205,"date":"2017-07-31T08:55:43","date_gmt":"2017-07-31T06:55:43","guid":{"rendered":"http:\/\/www.ayhanarda.com\/blog\/?p=1205"},"modified":"2017-07-31T08:55:43","modified_gmt":"2017-07-31T06:55:43","slug":"the-sql-server-service-broker-for-the-current-database-is-not-enabled-and-as-a-result-query-notifications-are-not-supported-please-enable-the-service-broker-for-this-database-if-you-wish-to-use-not","status":"publish","type":"post","link":"https:\/\/www.ayhanarda.com\/blog\/2017\/07\/the-sql-server-service-broker-for-the-current-database-is-not-enabled-and-as-a-result-query-notifications-are-not-supported-please-enable-the-service-broker-for-this-database-if-you-wish-to-use-not\/","title":{"rendered":"The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.  Please enable the Service Broker for this database if you wish to use notifications hatas\u0131 ve \u00e7\u00f6z\u00fcm\u00fc"},"content":{"rendered":"<p>Web sitenizde mssql db kullan\u0131yor ve sitenize eri\u015fmeye \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda\u00a0The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications hatas\u0131n\u0131 g\u00f6r\u00fcyor iseniz sql sunucu taraf\u0131nda yapman\u0131z gereken bir i\u015flem bulunmakta.<\/p>\n<p>Mssql Management Studio u a\u00e7\u0131n\u0131z.<\/p>\n<p>\u0130lgili database i bulunuz ve sa\u011f t\u0131klay\u0131p properties ini a\u00e7\u0131n\u0131z.<\/p>\n<p>Sol men\u00fcden Options a geliniz.<\/p>\n<p>Service Broker b\u00f6l\u00fcm\u00fcnde Broker Enabled b\u00f6l\u00fcm\u00fcn\u00fc true olarak set ediniz.<\/p>\n<p><a href=\"http:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2017\/07\/mssql-service-broker.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1206\" src=\"http:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2017\/07\/mssql-service-broker.png\" alt=\"\" width=\"902\" height=\"619\" srcset=\"https:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2017\/07\/mssql-service-broker.png 902w, https:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2017\/07\/mssql-service-broker-300x206.png 300w, https:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2017\/07\/mssql-service-broker-768x527.png 768w, https:\/\/www.ayhanarda.com\/blog\/wp-content\/uploads\/2017\/07\/mssql-service-broker-720x494.png 720w\" sizes=\"auto, (max-width: 902px) 100vw, 902px\" \/><\/a><\/p>\n<p>\u0130\u015flem bu kadar.<\/p>\n<p>Ayhan ARDA<\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_toolbar\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/tr\/share-medium.png\" style=\"border:0px; padding-top: 5px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_t=new Array(\"Twitter\",\"Facebook\",\"Google Plus\",\"Pinterest\",\"Linkedin\");var hupso_background_t=\"#EAF4FF\";var hupso_border_t=\"#66CCFF\";var hupso_toolbar_size_t=\"medium\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"ayhanarda\";var hupso_url_t=\"\";var hupso_title_t=\"The%20SQL%20Server%20Service%20Broker%20for%20the%20current%20database%20is%20not%20enabled%2C%20and%20as%20a%20result%20query%20notifications%20are%20not%20supported.%20%20Please%20enable%20the%20Service%20Broker%20for%20this%20database%20if%20you%20wish%20to%20use%20notifications%20hatas%C4%B1%20ve%20%C3%A7%C3%B6z%C3%BCm%C3%BC\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/share_toolbar.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"Web sitenizde mssql db kullan\u0131yor ve sitenize eri\u015fmeye \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda\u00a0The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications hatas\u0131n\u0131 g\u00f6r\u00fcyor iseniz sql sunucu taraf\u0131nda yapman\u0131z gereken bir i\u015flem bulunmakta. Mssql [&hellip;]","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"categories":[482],"tags":[432,1157,1156],"class_list":["post-1205","post","type-post","status-publish","format-standard","hentry","category-mssql-2","tag-mssql","tag-mssql-db","tag-service-broker"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/1205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/comments?post=1205"}],"version-history":[{"count":1,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/1205\/revisions"}],"predecessor-version":[{"id":1207,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/1205\/revisions\/1207"}],"wp:attachment":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/media?parent=1205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/categories?post=1205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/tags?post=1205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}