If there are multiple databases on a MS SQL server, do I have to do anything such as:

USE DATABASE


USE DATABASE1
SELECT ... FROM .... WHERE ....


The admin had connected the database server through another database name other than the one I mentioned above and it wants to default to it. I think this is a load of dung if it defaults to a particuliar database. However it keeps giving me errors and will not connect to the database I want to select tables from.

Anyone know anything about this?

neuro,

You should be able to use

SELECT .....
FROM dbase.owner.tablename

to point to your correct table.

T