Today, I was asked to reseed a table. I went to object explorer and tried to changed the seed to 50000. It didn't allow me to make the changes. The message that I got back was to drop and recreate the table. After some research I found an easier way to do it.
DBCC CHECKIDENT (MedicalSchoolApplicant, reseed, 49999).
Thank you, Pinal Dave for your suggestion.
No comments:
Post a Comment