InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 16:17:44 GMT20http://www.sqlservercentral.com/Forums/Topic739600-291-1.aspxTry this:sp_dropdistributor @no_checks=1,@ignore_distributor=1(Read more on the SP here: [url=http://msdn.microsoft.com/en-us/library/ms173516(SQL.90).aspx]http://msdn.microsoft.com/en-us/library/ms173516(SQL.90).aspx[/url])Thu, 25 Jun 2009 09:26:21 GMTKendal Van Dykehttp://www.sqlservercentral.com/Forums/Topic739600-291-1.aspxWe have a SQL server that was renamed. Replication was enabled when the server was renamed. When I right click on replication folder and choose publisher properties, the distributor name is the old server. The sql server instance and distributor does not match.There is also no distribution database.How can I change the name or remove replication from the server and start over?Mon, 22 Jun 2009 11:19:24 GMTcnadler3-1118456