>Somehow, a key record got deleted. This record has a primary key value of -1 in the field called PatientID. The patientID field is an Identity column. Is there a way to insert a new record and put the -1 value back into the table?
>
SET IDENTITY_INSERT MyTable ON
INSERT INTO MyTable (...) VALUES (...)
--sb--