var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL-2005 : set identity_insert <tablename> OFF
How to drop the identity if the table contains lakh of records using scripts.
Using the SQL 2005 tool, it's able to drop the identity for the table but i want to do it in scripts.
I tried with set identity_insert <tablename> OFF.
still the identity column is ON state only.
I dont know why..
I would appreciate if anyone reply for this...
In fact you have set the identity insert ON instead of OFF.
set identity_insert <tableName> ON
and again, when you are trying to insert a row using script in that table, if you want to insert the identity column's value, then you must specify the column names.
insert into <tableName>
(indentity_column_name, col1, col2, col3)
(10, 'as', 'as', 'sd', 'we')
But I dont think wat U said is I am looking for....
Wat I need is- To just drop the identity that is already set on my table using script.
set identity_insert <tablename> OFF is not working.. That is the problem..
Once again I thankU
You cannot permanently remove the IDENTITY property from an existing column. You will have to create a new column or a new table and copy the data into it. There's no other way I'm afraid.
thanku for Ur quick reply....