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).

alter an identity

2 Posts 2 Posters 0 Views 1 Watching

R Offline
R Offline
Rupa Kalluru

wrote on last edited by

#1

hi folks, Iam working sql server 2005 Iam unable to change the already existing identity value. Pls think a while for this,,,,,,i already tried alter table "ALTER TABLE ALTER COLUMN IDENTITY (x,y)" its urgent thanks in advance

Rupa
J 1 Reply Last reply

0
R Rupa Kalluru

hi folks, Iam working sql server 2005 Iam unable to change the already existing identity value. Pls think a while for this,,,,,,i already tried alter table "ALTER TABLE ALTER COLUMN IDENTITY (x,y)" its urgent thanks in advance

Rupa
J Offline
J Offline
JeganB

wrote on last edited by

#2

DBCC CHECKIDENT (jobs, RESEED, 30) I hope this will help to reset the identity value
1 Reply Last reply

0

Log in to reply