INSERT INTO FAIL ON MERGE REPLICA

Discussion in 'microsoft.public.sqlserver.ce' started by Fabrizio Innocenti via SQLMonster.com, May 3, 2005.

  1. Hi!

    i'm working on SQL SERVWER 2000

    i have replicated table and view (merge replica)

    but whene i try to execute
    "Insert INTO TABLE1 select campo1,..campoN from TABLE1 where recordnumber=
    N"

    (i have not included rowguid col in insert statement because should be
    automatic field)

    i receive an error on null value in rowguid column or better i receive
    error "column name or number of supplied values does not match table
    definition". the problem is on rowguid column. if i add newid() in insert
    statement the query is OK!

    Thanks!
     
    Fabrizio Innocenti via SQLMonster.com, May 3, 2005
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.