Home Forums SQL Server 7,2000 Replication "There are already statistics on table" error 1927 - can not resolve RE: "There are already statistics on table" error 1927 - can not resolve

  • Hi,

    I faced the same issue , on analysing I found that Article setting for "if the object with same name already exists" was to "Truncate table and reload data" . I modified it to "Delete the object and re-create" then it worked fine.

    Solution :

    Modified Article properties for the table

    Property : Action if name in use

    Earlier Value : Truncate All data in the existing object

    Fixed value : Drop Existing object and create a new one

    Regards,

    Avi