Browse by Tags

SSAS 2005 – Server side tracing starter kit

Analysis services 2005 (SSAS) added the ability to trace server side events and i have used this feature a number of times. To date i had always used the profiler gui to do the SSAS tracing but today i found myself needing to initiate and manage a trace with scripts. The good news is that it can be done...

Posted to Andrew Calvett (Weblog) by ACALVETT on 04-07-2008
What is that SPID doing?

This is certainly not a new topic but something that i felt was worth revisiting and reminding people about, especially because i find many people are not aware of the ability to extract the statement within a stored procedure being executed. So, prior to SQL 2000 SP3, when we want to know what code...

Posted to Andrew Calvett (Weblog) by ACALVETT on 03-27-2006
2005 - Alter failed for server XXX

Thats exactly what i thought!! What the hell does that mean? Well, for me this occured in the context of running the maintenance plan integrity check task. It had been running fine for weeks but suddenly boom every time it ran it would fail with "Alter failed for server XXX". There was no obvious reason...

Posted to Andrew Calvett (Weblog) by ACALVETT on 02-13-2006

Page 1 of 1 (3 items)

SQL Server Community Blogs