Happycat,

Thanks for the reply.As you have mentioned, we are using the identity(1,1) in our table.but each row has a foreign key branchid which will be unique for each database, say...