Trying To Change Identity On Field W/Data In SQL Manager

[FSUKXAZ]

I'm trying to change Identity on field w/Data using SQL Manager and cannot. The table is called Members and the field is called MemberID. It is already the Primary key, Not Null, and Unique according to SQL Manager. I'm trying to change the field to Identity with 500 as the first record and to increment by 1... kinda like this (500,1) because I already have 499 records in the table. Can someone please help?

[mbrazier]

I'm trying to change Identity on field w/Data using SQL Manager and cannot. The table is called Members and the field is called MemberID. It is already the Primary key, Not Null, and Unique according to SQL Manager. I'm trying to change the field to Identity with 500 as the first record and to increment by 1... kinda like this (500,1) because I already have 499 records in the table. Can someone please help?

What version of SQL? What data type is the MemberID field? In SQL2K, if the field is a numeric field (I usually use int or bigint for identity fields) then there should be no problem setting the MemberID field to be an identity field as long as all values are unique and not null. Can you provide more information about the table? Perhaps generate the sql script for the table including indexes, primary keys, foreign keys, defaults, and check constraints.