|
Subject:
|
insertion of records in database
|
|
Posted By:
|
MunishBhatia
|
Post Date:
|
12/12/2006 3:50:48 AM
|
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......
|
|
Reply By:
|
Jeff Moden
|
Reply Date:
|
12/12/2006 8:25:15 PM
|
Please post the INSERT statement that is causing the violation.
--Jeff Moden
|
