You all rule! Thanks for the advice; you have saved me from many hair-pulling hours of work. I am going to stick with an Active/Passive configuration and go...

Thank you for your responses and suggestions. I guess the really question than is should I split up the database so that I could run Active/Active and is there...

What I am referring to is the this part of the code:

insert into #TempTable

select 1,1,'Bob Smith' union all

select 2,1,'Dow Jones' union all

select 3,2,'Roberta Smith' union all

select 4,1,'John Dow' union all

select...

Thanks for the replies....

My problem is that the tblPersonnel table is 1000+ records and growing. So while the suggestions above would work, it would mean that I would have...