Problem changing my primary column

Question

I will need a script to change the identity column collation from only 3000 to 5000

Answer 1

SQLServer

DBCC CHECKIDENT ('TableName', RESEED, 5000)

http://msdn.microsoft.com/en-us/library/ms176057.aspx