how to reseed table to start at the PK 2? | ansaurus

tags:

sql-server-2008

views:

40

answers:

1

Q:

how to reseed table to start at the PK 2?

how to reseed table to start at the PK 2?

(SQL Server 2008)

+1 A:

DBCC RESEED: See example here: http://blog.sqlauthority.com/2007/03/15/sql-server-dbcc-reseed-table-identity-value-reset-table-identity/

Erich 2009-10-05 21:18:26

related questions

In SQL Server 2008 how can I secure data in a way that it cannot be decrypted unless connected to a network?

Advantages of MS SQL Server 2008 over MS SQL Server 2005?

SqlDataReader.HasRows returns false since SQL 2008 upgrade

How do I set the login info for SQL Server 2008 in Entity Framework?

Move SSIS Packages from SQL Server 2005 to 2008.

Installation problem sql server 2008

How do I register a Web Reference for a SQL Server 2008 Reporting Service Report?

How to use DataMining feature of SQL Server 2008 with ASP.Net

SSAS Cube Browsing not working after SQL 2008 CTP uninstall

Hooking up Reporting Services 2005SP2 to SQL Server 2008

New Date/Time data types in SQL 2008

Can SQLExpress 2005 and 2008 be installed on same machine without issue?

Any reason to have SQL Server 2005 and 2008 installed on same machine?

Cloud Hosting options for ASP.NET 3.5 and SQL Server 2008

How do I get the full name of the current user from a SQL Reporting Services 2008 report?

How do I fix a Cross language installation problem in SQL Server 2008?

Upgrade MSDE to SQL Server 2008

Reverse Engineering for Database Diagramming in Visio with SQL Server 2008

SQL Server 2008 Reporting Services Report Definition Customization Extensions

Moving SQL2005 app to SQL2008

Best practices for DateTime serialization in .Net framework 3.5/SQL Server 2008

Can I use SQL Server Management Studio 2005 for 2008 DB?

SQL 2008 Dialect Support for NHibernate

SQL Server 2008 vs 2005 Linq integration

SQL Server 2005 and 2008 on same developer machine?