>We have a file with identity column. An old record, with identity key value 6447, has been deleted by accident. I need to insert this record back with the same value. The file is live and in constant use. How can I insert this record back into the file.
Take a look at
SET IDENTITY_INSERT
T-SQL command.
--sb--