SQL Server Performance

Cube

Discussion in 'SQL Server 2005 Analysis Services' started by california6, May 1, 2008.

  1. california6 New Member

    We have 5 user's with admin rights on our OLAP Box. I see somebody created a new Cube on the OLAP Server and i was wondering, is there a way, i can track who created it? Appreciated if someone pleaes let me know.
    Thanks,
    california6, May 1, 2008
    #2

  2. MohammedU New Member

    I believe MS runs default trace for analysis services also but it keeps only 5 files at a given check those trace files...
    MohammedU, May 1, 2008
    #3

  3. california6 New Member

    Unfortunately I am running on SQL 2000. Is there a way to track this?
    california6, May 2, 2008
    #4

  4. satya Moderator

    What we do is check SQL error log and note the time when this cube is created, then check back on server event-viewer security log to compare the same time for the login that attempted.
    satya, May 2, 2008
    #5

Share This Page