Results 1 to 2 of 2

Thread: SQL Replication

  1. #1
    Join Date
    Dec 2002
    Location
    india
    Posts
    3

    Unanswered: SQL Replication

    Hi

    I am facing problem when i try to do replication between two server
    (both on world ip)

    error is :

    copying the data to another server, this error is shown -

    ------------------------------------------------------
    The process could not make a generation at the 'Subscriber'.
    (Source: Merge Replication Provider (Agent); Error number:
    -2147200994)
    ---------------------------------------
    Cannot insert the value NULL into column 'nicknames', table
    'NasscomData.dbo.MSmerge_genhistory'; column does not allow nulls.
    INSERT fails.
    (Source: 203.197.236.76 (Data source); Error number: 515)


    Regards

    Anil sharma

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Check for server name on subscriber - if it is null set any name.

    select @@servername

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •