<div>
DBCC CHECKIDENT (urColumn, RESEED, 300000)<br />

</div>


DBCC CHECKIDENT (urColumn, RESEED, 300000)


<div>
should I run that in query analyzer?<br />

</div>


<div>
what would the full statement look like? DBCC CHECKIDENT(mytable.mycolum<wbr />n, RESEED, 300000) ?
</div>


what would the full statement look like? DBCC CHECKIDENT(mytable.mycolumn, RESEED, 300000) ?

<div>
sorry for my first mistake.. Its 11.44 pm here .. need a good sleep :)
</div>


sorry for my first mistake.. Its 11.44 pm here .. need a good sleep :)

<div>
just 1 note (points for aneeshattingal):<br />
when you create the table, you can specify the identity seed:<br />
<br />
create table mytable ( identity_field int identity(300000, 1), &lt;other fields&gt; )<br />
<br />

</div>


just 1 note (points for aneeshattingal):
when you create the table, you can specify the identity seed:

create table mytable ( identity_field int identity(300000, 1), <other fields> )



<div>
<div class="content wysiwyg-content">
I have a table that has a n INT column that is used as a unique id, i was curious how I could have that column start at a number like 300,000 for example instead of defaulting to 1 when there is no data in teh table?<br />
<br />
<br />
Thanks!<br />
<br />
Loren
</div>
</div>


I have a table that has a n INT column that is used as a unique id, i was curious how I could have that column start at a number like 300,000 for example instead of defaulting to 1 when there is no data in teh table?


Thanks!

Loren

How do I set a start auto number for a sql server table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.