Drop Identity of a column

http://oldlook.experts-exchange.com/questions/20794028/Dropping-identity-contraint-for-a-column.html

Thanks,
I saw the link, but:

1. The first solution deletes the data of the table.
I need to keep the values of the Id.

2. Secound solution doesn't work out
Disabling Identity insert:
SET IDENTITY_INSERT <Table_Name> ON

WHAT TO DO ????
Thanks;
 :)

I forgot to mention, I need a query to do that...

where does the first solutions delete it?It is stored in newid column.Your id info is preserved !!

update ##tmp set newid=id

Ok, right! it inserts the data again,
but I can't do that since my table has a lot of colums and data.

i have try that it does not seems to work that is why i ask for the right script to run with the table sent to you

after 2 years ?

yeah, interesting :-)

two years of what angeiii

?
You posted and graded the q in dec 2003, now in mar 2005 you come back and tell us you have problems with it.

Thus: Comment from *catchmeifuwant*
>>after 2 years ?

And I only agreed that this time frame is interesting ...

Anyhow, WHAT is your exact problem right now?!

CHeers