Results 1 to 3 of 3

Thread: Ms Sql Replication

  1. 01-06-2005, 04:27 AM #1
    Colinpar
    Colinpar is offline Registered User
    Join Date
    Jan 2005
    Location
    Pretoria, South Africa
    Posts
    1

    Unhappy Ms Sql Replication

    Hi there, new member.

    Problem:

    Running Radical Call Center software on MS SQL. replicating between to servers, one way only. The auto-gen call no table is not replicated. Each server utilies a differt auto-gen number sequence. i.e. server A has '24' as it's prefix and server B has '1000' as it's prefix. Hence no duplicate records.
    T the subscriber, server A, an error 'call no already allocated' pops up every now and again. This occurs only when a new record is saved. (This should be impossible! as the 2 servers run different auto-gen sequences for call no's.)

    Any idea's as to what could cause the problem with the replication? Should I increae the interval between replication events?

    Colin
    Reply With Quote Reply With Quote
  2. 01-06-2005, 10:16 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Have you marked the column NOT FOR REPLICATION?

    For example

    CREATE TABLE authors ( COL1 INT IDENTITY (1, 1) NOT FOR REPLICATION PRIMARY KEY )
    Reply With Quote Reply With Quote
  3. 01-06-2005, 01:26 PM #3
    Rawhide's Avatar
    Rawhide
    Rawhide is offline Registered User
    Join Date
    Feb 2003
    Posts
    1,048
    Also. check to see if the tables have a check constraint on them. Use DBCC CHECKIDENT to see if either identity range is messed up.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules