I have exported the tables in the database from my pc to other server by using enterprise manager tool DTS program.
after exporting the tables i found that the columns originally with int IDENTITY were appearing as simple ints, without the identity tag.

i then tried to alter table with the following syntax.

alter table tbl
alter column "a" int identity(1,1)

it gives error "incorrect syntax near identity

pls help as to what will be the right query.
Thanks.
Rohit Sant.

I am not sure if you can do this with an ALTER table statement.

I tried this out by changing a column in an existing table and then looked at the change script that the Sql Server Enterprise Manager suggested. That script creates a new table with the new columns, copies the data in the new table and drops the old table.

If you want to try this out yourself: make a change to a table in EM and then click the Save Script icon....

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

i have a database prepared at my side. i have to put it on server side. i did that through DTS facility. all tables got successfully copied with the data. only thing remained is that the identity fields with int datatype were just int datatypes at client side without the identity property. on my side everything is correct. what should i do so that on the client side i make the fields as identity ones sitting from my end. i hope you got what i meant to say.

is there any way through EM, by which i can access the database of client from my pc and make necessary changes in client's database tables.

thanks.

If you use Copy SQL Server Objects task.. The identity column will stay intact.

thanks,both worked.