SQL Insert error Column name or number of supplied values I have one of the stored procedures for my replication giving this error 


  Insert Error: Column name or number of supplied value does not match table definition".


The stored procedure is spInsertsrra and the table is srra, I have put the syntax below for the 2 articles. 

       CREATE PROCEDURE SpInsertSrra @num_SessIdSession NUMERIC(10),
                                      @tin_SrraCptAnom1  TINYINT,
                                     @tin_SrraCptAnom2  TINYINT,
                                     @tin_SrraCptAnom3  TINYINT,
                                     @tin_SrraCptAnom4  TINYINT,
                                     @tin_SrraCptAnom5  TINYINT,
                                    @tin_SrraCptAnom6  TINYINT,
                                    @tin_SrraCptAnom7  TINYINT
AS
    INSERT INTO srra
    VALUES      (@num_SessIdSession,
                 @tin_SrraCptAnom1,
                 @tin_SrraCptAnom2,
                 @tin_SrraCptAnom3,
                 @tin_SrraCptAnom4,
                 @tin_SrraCptAnom5,
                 @tin_SrraCptAnom6,
                 @tin_SrraCptAnom7)

GO 

CREATE TABLE [SRRA] (
[SESS_ID_SESSION] [numeric](10, 0) NOT NULL ,
[SRRA_CPT_ANOM1] [tinyint] NULL ,
[SRRA_CPT_ANOM2] [tinyint] NULL ,
[SRRA_CPT_ANOM3] [tinyint] NULL ,
[SRRA_CPT_ANOM4] [tinyint] NULL ,
[SRRA_CPT_ANOM5] [tinyint] NULL ,
[SRRA_CPT_ANOM6] [tinyint] NULL ,
[SRRA_CPT_ANOM7] [tinyint] NULL ,
[rowguid]  uniqueidentifier ROWGUIDCOL  NOT NULL CONSTRAINT
           [DF__SRRA__rowguid__5F94079C] DEFAULT (newid()),
       CONSTRAINT [PK_SRRA] PRIMARY KEY  CLUSTERED 
           (
    [SESS_ID_SESSION]
         )  ON [PRIMARY] ,
         CONSTRAINT [FK_SRRA_CPTRS_ANO_SESS_SAN] FOREIGN KEY 
         (
    [SESS_ID_SESSION]
        ) REFERENCES [SESS_SANTE] (
    [SESS_ID_SESSION]
     )
          ) ON [PRIMARY]
          GO
SRRA has 9 columns, but you're only inserting 8. Specify DEFAULT for your rowguid column.

INSERT INTO srra
    VALUES      (@num_SessIdSession,
                 @tin_SrraCptAnom1,
                 @tin_SrraCptAnom2,
                 @tin_SrraCptAnom3,
                 @tin_SrraCptAnom4,
                 @tin_SrraCptAnom5,
                 @tin_SrraCptAnom6,
                 @tin_SrraCptAnom7,
                 DEFAULT)