Replication issue: Cannot insert the value NULL into column 'pubid', table IHpublications column does not allow nulls. INSERT fails.

[Query Builder]

Hi All,

I am working to setup a Transactional replication. The publisher is SQL 2005. I connect to find out that someone who had worked previously on the DB had setup the active user DB as the distribution DB. So it was under the System DB folder.

I managed to Disable replication and was able to release the User DB which was marked as the system Distribution DB. The DB is now marked as a user DB and I ran a DBCC consistency check to ensure the DB is not corrupt.

Then I proceed to setup replication. I am able to enable replication and was able to create new Distribution DB. When I go to add a publication from this user DB, I get the following error:

Cannot insert the value NULL into column 'pubid', table XXXX<UserDB>.dbo.IHpublications column does not allow nulls. INSERT fails.

It seems its looking into this <userDB>.dbo.IHpublications for some reason. It should in theory connect to distribution.dbo.IHpublications.

I have tried everything I can in terms of dropping the distribution DB again and rebuilding it. But I see no end to this issue.

I am wondering if anyone had seen this or have a solution for this issue. I would greatly appreciate any input or suggestions.

Thanks In advance..

Regards,
Query Builder.