Reset Increment Seed

I'm still in the development stage and am frequently deleting all data from all tables and then filling those tables anew. However, the increment seed for identifying fields doesn't reset to 1 (or 0--not sure which). While not important for operation of the database, I would prefer that the field identifiers start with 1 when I am ready to release the database for operation. Is there a way to do this?

I can generate scripts to rebuild the database structure to do this, but scripts aren't generated for database diagrams and the graphical representation of the table structure is very useful.

Hi Joe,

Truncate table reset the indentity. Truncate table is faster and need no transaction logs.

regards

Laurent

|||

You should take a look at DBCC CHECKINDENT in Books Online:

eg DBCC CHECKIDENT(YourTable, RESEED, 0)

HTH!

|||

Exception is that TRUNCATE TABLE will not work for table with reference to foreign keys. Almost all the table have references to foreign keys. Even when none of the tables have data in them, you still can not truncate the table.

Will try

DBCC CHECKIDENT(myTableName,RESEED,0) WITH NO_INFOMSGS

Reset Increment Seed

I'm still in the development stage and am frequently deleting all data from all tables and then filling those tables anew. However, the increment seed for identifying fields doesn't reset to 1 (or 0--not sure which). While not important for operation of the database, I would prefer that the field identifiers start with 1 when I am ready to release the database for operation. Is there a way to do this?

I can generate scripts to rebuild the database structure to do this, but scripts aren't generated for database diagrams and the graphical representation of the table structure is very useful.

Hi Joe,

Truncate table reset the indentity. Truncate table is faster and need no transaction logs.

regards

Laurent

|||

You should take a look at DBCC CHECKINDENT in Books Online:

eg DBCC CHECKIDENT(YourTable, RESEED, 0)

HTH!

|||

Exception is that TRUNCATE TABLE will not work for table with reference to foreign keys. Almost all the table have references to foreign keys. Even when none of the tables have data in them, you still can not truncate the table.

Will try

DBCC CHECKIDENT(myTableName,RESEED,0) WITH NO_INFOMSGS

sql

Requirements to set up on a new server?

I wanted to test drive the reporting services against Crystal.
I have a new stage server system where all servers were just promoted to
Win2003, and SQL 2000 on the data server box.
I understand that I need to put the reporting services on my IIS box. That
has .NET 2003 run time and SP applied.
When I attempt to install Reporting Services I get a lame error back about
lacking resources. This is the Reporting 2000 version. What am I missing?
TIA
__StephenWhat is the error? Please copy in the exact error message, and it's easier
to help. :) What resources are missing?
Have you installed Internet Information Services on your RS box? WIthout IIS
you won't get far with RS.
Kaisa M. Lindahl
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:OddBAscHGHA.1132@.TK2MSFTNGP10.phx.gbl...
>I wanted to test drive the reporting services against Crystal.
> I have a new stage server system where all servers were just promoted to
> Win2003, and SQL 2000 on the data server box.
> I understand that I need to put the reporting services on my IIS box.
> That has .NET 2003 run time and SP applied.
> When I attempt to install Reporting Services I get a lame error back about
> lacking resources. This is the Reporting 2000 version. What am I
> missing?
> TIA
> __Stephen
>