{"id":4163,"date":"2017-09-28T16:16:45","date_gmt":"2017-09-28T21:16:45","guid":{"rendered":"https:\/\/www.bhinfo.com.mx\/cursos\/?p=4163"},"modified":"2017-09-28T16:16:45","modified_gmt":"2017-09-28T21:16:45","slug":"mssql-drop-suscription","status":"publish","type":"post","link":"https:\/\/www.bhinfo.com.mx\/cursos\/2017\/09\/28\/mssql-drop-suscription\/","title":{"rendered":"MSSQL, Drop Suscription"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Modificar nombre de la publicaci\u00f3n y Base de datos<\/p>\n<pre class=\"lang:tsql decode:true \">--Select your publication database\r\n\r\nUSE identitum\r\nGO\r\n\r\nDECLARE @publication AS sysname;\r\nDECLARE @subscriber AS sysname;\r\n\r\n--enter your publication name\r\n\r\nSET @publication = N'Publish_Identitum';\r\n\r\n--enter subscriber name\r\n\r\nSET @subscriber = N'srvbiobdr';\r\n\r\nUSE identitum\r\n\r\nEXEC sp_dropsubscription\r\n@publication = @publication,\r\n@article = N'all',\r\n@subscriber = @subscriber\r\n,@ignore_distributor=1;\r\nGO\r\n\r\n--<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Modificar nombre de la publicaci\u00f3n y Base de datos &#8211;Select your publication database USE identitum GO DECLARE @publication AS sysname; DECLARE @subscriber AS sysname; &#8211;enter your publication name SET @publication = N&#8217;Publish_Identitum&#8217;; &#8211;enter subscriber name SET @subscriber = N&#8217;srvbiobdr&#8217;; USE identitum EXEC sp_dropsubscription @publication = @publication, @article = N&#8217;all&#8217;, @subscriber = @subscriber ,@ignore_distributor=1; GO [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[41,70,193],"tags":[343,249,53],"class_list":["post-4163","post","type-post","status-publish","format-standard","hentry","category-actividades","category-ddavila","category-sql","tag-drop","tag-replicacion","tag-sql"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/posts\/4163","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/comments?post=4163"}],"version-history":[{"count":1,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/posts\/4163\/revisions"}],"predecessor-version":[{"id":4164,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/posts\/4163\/revisions\/4164"}],"wp:attachment":[{"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/media?parent=4163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/categories?post=4163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/tags?post=4163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}