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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-08 : 17:09:06
|
| Jack writes "I used the DTS to copy a db schema and data from Access to SQL Server. What is the best way to "reset" my identity columns? Can I just set the column to "identity" w/ the seed value = to the maximum current column value?Thanks for your help...[I'm using SQL Server EM v8.0]" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2005-08-08 : 17:09:06
|
| A quick search of the site on "identity" returns this article: http://www.sqlteam.com/item.asp?ItemID=8003 |
 |
|
|
|
|
|
setting Identity column to a data-filled table