Distribution Database in Production Database


  • I have a SQL Server 2008 R2 Database that needs to be published for replication.

    In error I ran a script that sets up the distribution database. I put the name of the production database in the script rather than something like 'Distribution' this resulted in the Distribution tables etc. being created in the Production database.

    I now have the problem that when I try to create the publication it fails with an error cannot insert a record into IHpublications Nulls not allowed. (not the exact text).

    From what I have managed to find out is that a record is only inserted into here for non mssql databases.

    I have disabled Distribution and re enabled it using the SSMS wizard and I now have a 'Distribution' database under System Tables in the master. I can publish tables from other databases on the server but not the one that contains the distribution objects such as IHpublications.

    Does anyone know how to fix this? I needs to somehow undo what I have done.

    I would be grateful for any help/suggestions.



    Friday, July 12, 2013 6:53 PM


All replies