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

Pages

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
ORDER BY 1,2
Share this article :

1 comments:

  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,
    Morgan

    ReplyDelete