Thanks for your reply.

So is there no way that I can change the identity value after it is created once ?

as after doing the dbcc checkident...

I don't see the changes...

Thank you for ur quick response.

Please could you let me know how to do this in batches ... in jobs...

SRee

Thanks for your reply.

I couldn't understand wht made the difference.

For job also I can schedule it after working hours.

I thought like can we write a better query or do something...

Ya..as I said..we get the error and I resolved it..But when I compare with correct file name I didn't get the error. How come?

when I give a different file...