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

Repot Manager Hangs

This happens very frequently on our server and I can't determine the cause.
The basic issue is that SRs gets into a state where it hangs, you can't
render reports,you can't even vire proprties, navigate folder etc, so I know
its not extenal data sources.
One things I tried was disabling Script Blocking which was enabled on our
antivirus. This is mentioned in this Kb:
http://support.microsoft.com/kb/295375/en-us
I also set the IIS Idle rest to 8 hours. But that wasn't the initial issue.
I've been looking at perfmon (thread counts, pages\sec, disk queues, working
set, etc.) and I'm not seeing some obvious resource constraint\bottleneck.
I appreciate any addiional info on things to try.
Thanks,
-pWhat version?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peaboy" <Peaboy@.discussions.microsoft.com> wrote in message
news:96C28CF8-0A0B-4C75-9811-5884A172385E@.microsoft.com...
> This happens very frequently on our server and I can't determine the
> cause.
> The basic issue is that SRs gets into a state where it hangs, you can't
> render reports,you can't even vire proprties, navigate folder etc, so I
> know
> its not extenal data sources.
> One things I tried was disabling Script Blocking which was enabled on our
> antivirus. This is mentioned in this Kb:
> http://support.microsoft.com/kb/295375/en-us
> I also set the IIS Idle rest to 8 hours. But that wasn't the initial
> issue.
> I've been looking at perfmon (thread counts, pages\sec, disk queues,
> working
> set, etc.) and I'm not seeing some obvious resource constraint\bottleneck.
> I appreciate any addiional info on things to try.
> Thanks,
> -p|||SQL 2005 w/ latest SPs and fixes.
"Bruce L-C [MVP]" wrote:
> What version?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Peaboy" <Peaboy@.discussions.microsoft.com> wrote in message
> news:96C28CF8-0A0B-4C75-9811-5884A172385E@.microsoft.com...
> > This happens very frequently on our server and I can't determine the
> > cause.
> > The basic issue is that SRs gets into a state where it hangs, you can't
> > render reports,you can't even vire proprties, navigate folder etc, so I
> > know
> > its not extenal data sources.
> >
> > One things I tried was disabling Script Blocking which was enabled on our
> > antivirus. This is mentioned in this Kb:
> > http://support.microsoft.com/kb/295375/en-us
> >
> > I also set the IIS Idle rest to 8 hours. But that wasn't the initial
> > issue.
> >
> > I've been looking at perfmon (thread counts, pages\sec, disk queues,
> > working
> > set, etc.) and I'm not seeing some obvious resource constraint\bottleneck.
> >
> > I appreciate any addiional info on things to try.
> >
> > Thanks,
> > -p
>
>