Hi,

I think you could try this;

DECLARE @DataBaseName varchar(10)

SELECT @DataBaseName = 'DataBase_A'

EXEC ('SELECT * FROM ' + @DataBaseName + '..tablename')

You could make the table a variable as well.

Hope this helps.

Jon

Ok I might have missed the point, I'll try to clarify what I mean if it still doesnt make sense then maybe I dont understand what you want.

I set up...

You can have a different user name to that of your login, although not that advisable as it can cause confusion.

The Login Name relates to the actual login name and...