SQL Server Profiler

• brian.goode

  Newbie

  Points: 1

  More actions

  November 28, 2008 at 1:39 am

  #196438

  Hi All,

  A strange issue.

  On an MSAS system we have three separate cubes. I am included in the Admin role of each cube.

  I am able to browse each cube using the Management Studio and expect to see the MDX query information in the SQL Server profiler.

  The issue is that for two of the cubes I am unable to view the MDX query information in the SQL server profiler, for the third is is possible to obtain the MDX query information.

  I have checked that I am connected to the correct AS Server - the same for all three cubes.

  Curiously another user is able to trace all three cubes; which possibly indicates an authorization issue.

  Can anyone provide some pointers?

  I have been tearing my hair out with this.

  Best regards,

  Brian

• Adam Wilbur

  SSCertifiable

  Points: 7001

  More actions

  December 1, 2008 at 3:38 pm

  #905961

  What server roles / permissions do you have? Do you have alter trace permissions on the server? You sure it's not a lingering filter in Profiler?

  
  
  A.J.
  DBA with an attitude