Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Thursday, 16 June 2016

Query to get Database Links

SELECT owner            "Owner"
,      db_link          "Link Name"
,      username         "Username"
,      created          "Created"
,      host             xonly_host
FROM   all_db_links
Share this article :


  1. Hi Dayakar,

    What a brilliant post I have come across and believe me I have been searching out for this similar kind of post for past a week and hardly came across this.

    I am using Microsoft Visual Studio 2015 (as SSDT) to develop a cube on SQL 2014 standard edition with Analysis Services installed in Multidimensional mode.
    The cube gets deployed to Analysis Services and also gets processed without errors. I can browse the cube from SSMS, but cannot brows it from Visual Studio Cube browser. The error I am getting is :
    "Errors related to feature availability and configuration: The 'Tabular View' feature is not included in the '64 Bit Standard' edition of Analysis Services. (Microsoft SQL Server 2014 Analysis Services)
    Why is it trying to browse in Tabular view? How do i set it to browse in Multidimensional view?

    I look forward to see your next updates.

    Thanks a heaps,