From a management studio query window, I know I can run:
select * from sys.objects
from the database I'm currently connected.
How can I run this select to a different database on the server without using the drop down and changing the database. Also, I don't want to have to utilize the USE statement.
While connected to master, I've tried
select * from msdb.dbo.[sys.objects]
and
select * from msdb.dbo."sys.objects"
but they don't work.