Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SubPar_Coder
Starting Member
23 Posts |
 Posted - 2005-05-18 : 12:19:37
|
| Is there a way to set the start number for the identity field in SQL? I have a stored procedure that handles all the input and auto incriments the identity field. I tried to go into the chart and manually do it but it wouldn't let me.Any ideas?Jack of all trades, Master of none! |
|
|
uberman
Posting Yak Master
159 Posts |
Posted - 2005-05-18 : 12:28:36
|
| Have a look for DBCC CHECKIDENT in BoL(This example forces the current identity value in the jobs table to a value of 30.USE pubsGODBCC CHECKIDENT (jobs, RESEED, 30)GO) |
 |
|
|
|
|
|
Start# for identity column??