Hello to all
i have table having following columns in it:
PK JoinInviteeID INT 4 Identity(1,1)
    ValidKey int 4 random
    UserID INT 4
    DisplayName nvarchar 50
    ToEmailAddr nvarchar 80
    FromEmailAddr nvarchar 80
    MessageBody nvarchar 250
    Subject nvarchar 50
    FirstSent datetime 8
    LastSent datetime 8
    SendCount tinyint 1 (0)
    FirstViewed datetime 8
    LastViewed datetime 8
    SendAsUser bit 1 (0)
    SMTPSent bit 1 (0)
    SMTPError bit 1 (0)
    LastUpdate Datetime 8
    SMTPSendCount tinyint 1 (0)
    RequestCount tinyint 1 (0)

I am unable to insert the values in it. even i set insert_identity ON
it displays error message as:
"Explicit value must be specified for identity column in table 'JoinInvitees' either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column.
"

plz help me..........



thanks......

__________________
thanks......

Please post the INSERT statement that is causing the violation.

--Jeff Moden