How Reset Transaction Number to 1

Hi Mjay, It normally not happen as you said I tried to "Delete the Transaction" first and then system has also reseted the Sequence No. You make sure that you are in Database Menu then click on "Delete Transactions" button

else if this won't work then you go to to sql enterprise > database > rmsdb

right click on this and open in design mode. then go to TransactionNumber Field and on the column property and Make Identity field proper to No and then save the table I mean close X button.

Re do the same thing and then this time enable the identity field to Yes. and save the table.

I use this way of work around there are scripts also which do but I don't have right now.

"MJay" wrote:

If you absolutely must have transaction #1, you should start a new database.

Trying to delete or change the transaction table will probably not go well. Forget about it. >99% of the time modifiying/deleting the transaction table

Why is it so critical for the next Transaction to be Number One. Why not

Tom

dbcc checkident ( 'item' ,reseed, 1)

Glenn Adams Tiber Creek C> How do i reset the transaction number to 1 after i have clear all the sales

HI Mjay, Yes you can do the same thing to run this script to transaction table: dbcc checkident ( '[transaction]' ,reseed, 1)

You can run the above script to any table which has wrong identitiy seed assign, which normally not happen.

"MJay" wrote: