Post reply

error 627

  • December 16, 2004 at 10:36 am

    #163274

    I'm using transactional replication between 2 servers running W2K . When trying to create publications I'm getting Error 627: " cannot use Save transaction within a distributed transaction".

    Does somebody know anything about why is this happening ?

    Thanks in advance.

  • December 20, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • December 20, 2004 at 9:49 am

    #534492

    Check syscomments table, if any of stored procedures have "SAVE TRAN" string. To fix error you will need to rewrite this procedure or set trace flag 8599. May be there is another reason, but check this first. This is an article from Microsoft: http://support.microsoft.com/kb/295027/EN-US/

  • December 20, 2004 at 10:13 am

    #534501

    Appreciate an effort , but This is not an issue

    Thank you

  • December 21, 2004 at 6:57 am

    #534598

    Run sp_helpArticle at the publisher and check what stored procedures are used at the subscriber to replicate data (ins_cmd, upd_cmd, del_cmd).

    Then at the subscriber, run sp_helptext [sp_name] and search for any BEGIN TRAN. That shoudn't be in there, so erase any BEGIN ROLLBACK or COMMIT TRAN.

  • December 21, 2004 at 9:14 am

    #534636

    The problem is :

    while I keep getting this error

    there is no Publication being created

    and therefore there is no sp_MSins_tblName

    or anything on the subscriber.

    ----

    I found the solution , don't know how it will influence everything else, but it lets me create a publication.

    SP_Configure 'remote proc trans' option has to be set to 0 (!)

    ---------------

    Thanks to everybody who tried to help

Viewing 6 posts - 1 through 5 (of 5 total)

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