identity column (SQL2K)

I think you have to do this within Enterprise Manager by unchecking the IDENTITY option in the Design View of the table.
Using the ALTER TABLE...ALTER COLUMN statement doesn't appear to drop the IDENTITY option

I KNOW I CAN DROP IT IN eNTERPRISE Manager , but i actally need a  TSQL script to do it

Richardsoet - would you mind closing some of your existing questions?  Including this question, you have 10 questions open, several of which have either been answered or need your participation to continue.

I've had a search and found this: https://www.experts-exchange.com/questions/20829246/Drop-Identity-of-a-column.html
(thought I'd remembered seeing this crop up before!)

Basically, you cannot simply drop the IDENTITY option. You have to create a new column, copy all the existing identity column values into this new field, drop the existing IDENTITY column and then rename the new column.

i have ask this question more than ten times , that how do i close down calls , no one get back to me , i will be happy if you can tell me the procedure to follow to close down calls thanks

To close a question, please see here: https://www.experts-exchange.com/help.jsp#hi9

Thanks

If you do not have an answer, don't close the question, but there are 6 questions where other experts have responded after you and you have not given any feedback regarding their comments.  They can't help you unless you work with them.  In addition, there are at least 2 questions that appear to be answered.

Awaiting comments from you:
https://www.experts-exchange.com/questions/21349518/WebSphere-with-GZIP.html
https://www.experts-exchange.com/questions/21401316/sql-TABLE.html
https://www.experts-exchange.com/questions/21414990/sql-sCRIPT.html
https://www.experts-exchange.com/questions/21418144/sql2000.html
https://www.experts-exchange.com/questions/21418151/sql2k.html
https://www.experts-exchange.com/questions/21407235/sql-tABLE.html

Appear to be answered:
https://www.experts-exchange.com/questions/21400982/SQL.html
https://www.experts-exchange.com/questions/21401031/Triger.html

How to close questions:
https://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi68

Rather than asking a question over and over, please post 20 point pointer questions to the original question.

>>I KNOW I CAN DROP IT IN eNTERPRISE Manager , but i actally need a  TSQL script to do it <<
david_chiu has demostrated how you can do this with Enterprise Manager. Just look for the "Save change script" icon.

P.S. Please lose the ALL CAPS it looks like you are yelling.