hi,

i am using sql server 7.0 when trying a row on a identity column i am getting the following error

Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'TenderDetails' when IDENTITY_INSERT is set to OFF.

How do I make identity_insert to ON?
I tried giving at procedure, but it did not work.
can anyone help me out