locked
SQL Server Linked server & Catlogs RRS feed

  • Question

  • Hi,

      In Linked servers I have found catalog folders which is displaying the DB name of the linked server. what is the catalog?

    Friday, December 6, 2013 10:26 AM

Answers

  • what is the catalog?


    It's the catalog of objects on the next deeper level. If your linked server is pointing to an other SQL Server, then the "Catalog" shows all existing databases, if it points to Oracle it shows the schemas and so on.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Sofiya Li Tuesday, December 10, 2013 2:18 AM
    • Marked as answer by Sofiya Li Friday, December 13, 2013 9:43 AM
    Friday, December 6, 2013 11:01 AM
  • Hi winoa,

    In addition, the catalog is used when a connection is made to the OLE DB provider. Catalog is sysname, with a default of NULL. Catalog is passed as the DBPROP_INIT_CATALOG property to initialize the OLE DB provider. When the linked server is defined against an instance of SQL Server, catalog refers to the default database to which the linked server is mapped. You can also use sp_catalogs to return the list of catalogs in the specified linked server.

    For more information, you can review the following article.
    http://technet.microsoft.com/en-us/library/ms190479.aspx

    Thanks,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    • Marked as answer by Sofiya Li Friday, December 13, 2013 9:43 AM
    Tuesday, December 10, 2013 2:28 AM

All replies

  • what is the catalog?


    It's the catalog of objects on the next deeper level. If your linked server is pointing to an other SQL Server, then the "Catalog" shows all existing databases, if it points to Oracle it shows the schemas and so on.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Sofiya Li Tuesday, December 10, 2013 2:18 AM
    • Marked as answer by Sofiya Li Friday, December 13, 2013 9:43 AM
    Friday, December 6, 2013 11:01 AM
  • Hi winoa,

    In addition, the catalog is used when a connection is made to the OLE DB provider. Catalog is sysname, with a default of NULL. Catalog is passed as the DBPROP_INIT_CATALOG property to initialize the OLE DB provider. When the linked server is defined against an instance of SQL Server, catalog refers to the default database to which the linked server is mapped. You can also use sp_catalogs to return the list of catalogs in the specified linked server.

    For more information, you can review the following article.
    http://technet.microsoft.com/en-us/library/ms190479.aspx

    Thanks,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    • Marked as answer by Sofiya Li Friday, December 13, 2013 9:43 AM
    Tuesday, December 10, 2013 2:28 AM