Replication

  • I once tried to publish from a named instance to sqlexpress. I configured the named instance as the publisher and sqlexpress as the one who receives the data. But the replication did not work properly.

    Apart from that my data base in the named instance is not allowing any change to the table and gives an error message ' The table is under replication '

    Can anybody guess what mistake I have done and is there any way to correct this problem?

    V.Kadal Amutham

    vkadal@gmail.com

  • Obviously, SQL Server is still thinking that your database is still part of the replication. Unfortunately you don't write what kind of replication you (tried) to set up or how you removed it.

    Do you still have a publication ? If yes, remove it and try again. If it's still not working, you might end up cleaning up the distribution database manually.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • Dear Markus,

    The following is the error message I am gettin when I try to modify any table. Please help

    V.Kadal Amutham

    /*

    Wednesday, January 11, 20062:56:17 PM

    User: sa

    Server: KOVAI\JANAKI

    Database: SukaNaSizing

    Application:

    */

    'Attendance' table

    - Unable to modify table.

    Could not retrieve replication information for table 132195521. Verify that the table has a primary key, and then rerun the Log Reader Agent.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply