Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Reset autonumber (ID) in SQL Server

2 Posts 1 Posters 0 Views 1 Watching

M Offline
M Offline
Matjaz xyz

wrote on last edited by

#1

Hi. Is it possible to reset the autonumber of a ID in MS SQL Server?

Regards, Matjaž
M 1 Reply Last reply

0
M Matjaz xyz

Hi. Is it possible to reset the autonumber of a ID in MS SQL Server?

Regards, Matjaž
M Offline
M Offline
Matjaz xyz

wrote on last edited by

#2

OK, found it on Google. I had to run a query "DBCC CHECKIDENT (yourtable, reseed, 34)". Got it off of a . Pinal Dave blog

Regards, Matjaž
1 Reply Last reply

0

Log in to reply