Thank you for your reply!
I gave the sequence object a try, however when I manually execute the SQL statements I wrote in SSMS it only writes the first number, "1". Then, I need to DROP the sequence prior to manually executing it a second time in SSMS, because I get the following error "There is already an object named 'serial_number_seq' in the database." I pasted my SQL statements below. Can you help me make so it will enter all sequence entries at once (in the code below I'm expecting 11 records, since the MAXVALUE is 11)?
CREATE SEQUENCE serial_number_seq
START WITH 1
INCREMENT BY 1
INSERT INTO Serial_Data
(Serial_Number, Serial_State, Case_Counter, Date_Time)
(NEXT VALUE FOR serial_number_seq, 'unused', 0, GETDATE());