Post reply

Linked Server

  • August 3, 2010 at 2:46 am

    #142136

    Hi

    Linked server show only default database while using sa credentials. There are several other databases on that server but those are not visible in the linked server.

  • August 3, 2010 at 4:19 am

    #1201432

    What does the four part query (ServerName.DatabaseName.OwnerName.ObjectName) return?

    Does it throw any error?

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • August 3, 2010 at 5:01 am

    #1201445

    If I query useing servername.database.schema.tablename it returns records, but in management studio I can't see the databases, its just linked server node.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply