^{Can you specify what are the number of rows being returned by each query?}

^{Casue I had the same problem and noted that the time lag was directly proportional to the...}

Thanks guys..But I already have a delay betwen the two.

I cannot call the 2 SPs from 1. Cause that 2nd depends on user interaction.

Thanks

SG

Thanks David for ur response.

Yes the 2 databases have different collations. But i tried to define a #table with the same collation as DatabaseB and inserting the data into it,...