Alter Table? Identity

[xtendscott]

OK, an ISP did a restore from my database backup and I think it lost its IDENTITY value. I have tried the following code to fix it but I get a "Incorrect syntax near the keyword 'IDENTITY'."

<cfquery name="alter_Table" datasource="#application.dsn#" username="#application.datalogin#" password="#application.datapass#">
	ALTER TABLE users
		ALTER COLUMN user_ID INT IDENTITY(60,1) NOT NULL 

</cfquery>

It needs to remain its Primary Key value too.

Thanks in advance.

 

[JohnDTampaBay]

If you are trying to reseed the identity column to a specific value in MS SQL Server...

DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)

--Angel
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)