How to turn off identity for a database column of a table I have mistakenly deleted a table in one one my database server. I have same set of data in the other server.

What I have done is clicked on edit top 100 rows for the table, then copied it and pasted in the other server table.

But , here the problem is : one of the columns of the table is an identity. So, i was unable to copy that column here.

I need same identity values because these values are referred in the application, even if i copy the data and update it, new id values are being generated.

Is there any way to turn off identity for that column, paste these values and again turn on identity.
If I understand you correctly, try this one -

SET IDENTITY_INSERT &lt;your_table&gt; ON

INSERT INTO ... (ID, ...)

SET IDENTITY_INSERT &lt;your_table&gt; OFF