Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2009
    Location
    France
    Posts
    6

    Question Unanswered: [SQL SERVER 2k5]List databases on a linked server

    Hello,
    I would like to know the list of the databases on a linked server.

    Does it exist a command like sysobjects that can be executed on the linked server ?

    Or something like
    Code:
    select * from NameOfTheLinkedServer.sys.databases
    Thanks.

    Last edited by ludo27; 03-24-09 at 11:55.

  2. #2
    Join Date
    Aug 2005
    Posts
    75
    Code:
    select * from NameOfTheLinkedServer.master.sys.databases

  3. #3
    Join Date
    Feb 2009
    Location
    France
    Posts
    6

    Wink

    Quote Originally Posted by jeebustrain
    Code:
    select * from NameOfTheLinkedServer.master.sys.databases
    It works. Thank you jeebustrain

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •