Ok, I went back to BOL and looked at the syntax.

The IDENTITY option is only available if you are adding a column. ALTER COLUMN allows you to add or drop ROWGUIDCOL but not IDENTITY.

EM does it by creating a new table with the IDENTITY property, copying the data to it, dropping the old table, and renaming the new table. That's what your script will probably reveal.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1