Hi Ray,

Actually I have:

/** first table; each business unit has a copy where OrderID,OrderName combination is in any combination ***/

Create Table #Ref_Preferance(OrderID smallint not null

,OrderName varchar(10) Not Null)

Insert into #Ref_Preferance...

Thanks a lot guys,

Srini, your solution worked and I could reduce the transaction log...

Andrew, I will take a look into this further and hopefully fix so that this does...

Thanks for all your solutions...I will try and will let you guys know how it worked out.

Thanks again

I tried using 'Select suser_sname' and it returned 'sa' and 'Select user_name' returned 'dbo', as the results. Where as, I am logged into Windows as 'rnandan' and this is the...

Thanks...will look into that. I knew regulations will cost businesses but we need to meet them...irrespective. Thanks anyway