Thanks everybody for the reply. I will have to create staging tables for the joins I guess.

Thanks!

I had to restart the server and I could login as sa. Thanks a lot for the solution!

I did that. The value is 2 now. but I get the error that "sa" is not associated with a trusted connection. any other ideas?

Thanks.

I did that. The value is 2 now (it was 1 earlier) . but I get the error that "sa" is not associated with a trusted connection. any other ideas?

Thanks.

thanks for the reply, but how will I build the global variable? Will I not have to hardcode the value of the global variable in the code, or read it from...