Dear Sir/madam

I want an example or Utility to Set Identity = True in SQL Server Table

If it is in a Script then it will be best.

I tried many ways but it is not changing Identity Field = True But manualy it is possible.

I have around 100 Table which is transfered from Access MDB so please suggest/Give some idea so that I donot have to repeat the process . As this database will be installed for trial in 3 to 4 Places.

Thanks in Advance