Linked Server Table List Limited to One DB

• eightnothing

  Newbie

  Points: 1

  More actions

  October 6, 2004 at 3:55 pm

  #361190

  I'm new to SQL Server...

  I'm using SQL security to set up a linked server. However, the tables listed in the linked server window in EM are limited to system tables and only the tables of the default db of the SQL login.

  I need to list tables from several dbs, not just the default db and cant find a way to do this, despite the fact that the SQL login is set as SQL System Administrator.

  Does anyone know...

  1. Is it possible?

  2. How to set up this user?

  Any help greatly appreciated.

• October 11, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Kathi Kellenberger

  SSChampion

  Points: 11811

  More actions

  October 11, 2004 at 12:38 pm

  #526237

  To see data in databases besides the default run this in Query Analyzer:

  Select * from linkedservername.databasename.dbo.tablename

   

   

  Aunt Kathi Data Platform MVP
  Author of Expert T-SQL Window Functions
  Simple-Talk Editor