If you look at current activity in SQL Server 2005 or 2008 or 2008 R2, you may notice some some sessions coming from Analysis Services where last_wait_type is TRACEWRITE. For example, when you query like this: SELECT * FROM sys.dm_exec_requests; SELECT...

  To make a new dimension or any object in an SQL Server 2008 Analysis Services database, the user must be in a role that has “Full control ( Administrator)” permissions. I confirmed this by breaking my role, getting an error, and researching the...