Recent content by danmore

Ashley and bp, thanks guys! It is indeed possible to change a column to an Identity type using the design view so I thought that if you could do it in one way there should be a way to do it in another. But I guess I can't. When I do the conversion, using the DTS wizard, I import the data...

Ashley, I must be doing something worng! I do the following: use InHouse go create table test ( t1 int, t2 char(2) ) go alter table InHouse.dan.test alter column t1 int not null go alter table InHouse.dan.test alter column t1 int IDENTITY (1,1) not null go On the last command I get...

Ashley, the converted field is an INT type. The question is how do I alter an INT type field into an INT IDENTITY type field? Thanks

Thank you both Ashley and bp. I guess I should have been a little more specific. I have about 100 tables in this database and would like the conversion to be done using a t-sql procedure or use the DTS wizard directly? I have looked in the documentation for the alter table syntax and It...

I am trying to convert an Access 2000 database into SQL Server 7. The DTS wizard maps AutoNumber fields into an INT field type. I wonder if there's a way (1) to alter the INT field to an Identity field after it's created? or (2) to force the the DTS to convert AutoNumber Access fields to and...