Using Query Analyzer
ALTER TABLE testing1 DROP COLUMN Cid
GO
ALTER TABLE testing1 ADD Cid INT IDENTITY (1,3) NOT NULL
GO
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]