Querying a Catalog view in a different database

• Mark Yelton

  SSCommitted

  Points: 1570

  More actions

  March 4, 2010 at 2:09 pm

  #137580

  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.

• Toby White

  SSCertifiable

  Points: 6187

  More actions

  March 4, 2010 at 2:21 pm

  #1128781

  select * from msdb.sys.objects

  sys is the schema, not dbo.

  Regards,

  Toby

• Mark Yelton

  SSCommitted

  Points: 1570

  More actions

  March 4, 2010 at 2:39 pm

  #1128795

  Thank you.