Change Identify Type Column from starting from 1
Is there a way to change a id column that has an identify type that increments each time a new row is inserted. For example if its a prior table with 50,000 rows can i have it start at 50,000 and increment to 50,001 on the next insert? Is there a sql query i could write for this or a way in the GUI to fix this?
