I also encounter this problem. However, I don't want to use sp_chang_users_login because this store procedure is for sysadmin users (ex: "sa",...). Can we solve this problem by User U?

Thanks...

Thank you very much for interested in my question. However, I find out answer from here : http://social.msdn.microsoft.com/Forums/en/transactsql/thread/07dd8fb0-4c2c-4ed0-a6a6-4ca6a488f2d0

Again, thanks anyway and hope continue getting your help for...

Maybe I must reset it manually. Thanks so much for taking part in reply my question.

I think Sql can delete all data of child tables when a parent table is deleted cascade then why there is no way to reset identity of child tables. How...

My goal is able to get a database which have empty tables like as beginning without using file bak.

I learn something new from this question. Thank you!

Thanks for your reply, Ten Centuries!:)

Yes. Thanks so much for your replys, Scott Duncan and Ten Centuries! Maybe i should explain more details about my problem.

For example:

Table's Name is TABLE1:

[Code] varchar(1), not null

[IngNo] int, not...