{"id":4166,"date":"2017-09-28T19:15:23","date_gmt":"2017-09-29T00:15:23","guid":{"rendered":"https:\/\/www.bhinfo.com.mx\/cursos\/?p=4166"},"modified":"2017-09-28T19:15:23","modified_gmt":"2017-09-29T00:15:23","slug":"mssql-drop-publish","status":"publish","type":"post","link":"https:\/\/www.bhinfo.com.mx\/cursos\/2017\/09\/28\/mssql-drop-publish\/","title":{"rendered":"MSSQL, Drop Publish"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Ejecutar&nbsp; la ultima parte del script si el distribuidor ya no existe.<\/p>\n<pre class=\"lang:tsql decode:true \">__\r\nDECLARE @publicationDB AS sysname;\r\nDECLARE @publication AS sysname;\r\n\r\n--set your publication database here\r\n\r\nSET @publicationDB = 'Identitum';\r\n\r\n--set your publication name here\r\n\r\nSET @publication = N'Publish_Identitum';\r\n\r\n-- Remove a transactional publication.\r\n\r\nUSE identitum\r\nEXEC sp_droppublication\r\n\r\n@publication = @publication\r\n,@ignore_distributor=1;\r\n\r\n-- Remove replication objects from the database.\r\ngo\r\nUSE [master]\r\n\r\nEXEC sp_replicationdboption\r\n@dbname = @publicationDB,\r\n@optname = N'publish',\r\n@value = N'false';\r\nGO\r\n\r\n\r\n--execute following command on distributor server\r\n\r\nUSE master\r\nGO\r\n\r\nEXEC sp_dropdistributor @no_checks = 1, @ignore_distributor = 1\r\nGO\r\n\r\n\r\n--Este script fue el que funciono\r\nuse identitum\r\nexec sp_removedbreplication @dbname = 'Identitum'\r\n\r\n--<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Ejecutar&nbsp; la ultima parte del script si el distribuidor ya no existe. __ DECLARE @publicationDB AS sysname; DECLARE @publication AS sysname; &#8211;set your publication database here SET @publicationDB = &#8216;Identitum&#8217;; &#8211;set your publication name here SET @publication = N&#8217;Publish_Identitum&#8217;; &#8212; Remove a transactional publication. USE identitum EXEC sp_droppublication @publication = @publication ,@ignore_distributor=1; &#8212; Remove [&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":[1],"tags":[],"class_list":["post-4166","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/posts\/4166","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=4166"}],"version-history":[{"count":1,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/posts\/4166\/revisions"}],"predecessor-version":[{"id":4167,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/posts\/4166\/revisions\/4167"}],"wp:attachment":[{"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/media?parent=4166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/categories?post=4166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/tags?post=4166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}