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?