For those of you with the assembly from the Analysis Services Stored Procedure project installed you can go one step further and use the following.
CALL ASSP.ClearCache("Adventure Works")
GO
SELECT {} ON 0
FROM [Adventure Works]
A dump of all things SQL Server, SQL Reporting Services, Analysis Services, around Business Intelligence, Business Performance Management and technology.
For those of you with the assembly from the Analysis Services Stored Procedure project installed you can go one step further and use the following.
CALL ASSP.ClearCache("Adventure Works")
GO
SELECT {} ON 0
FROM [Adventure Works]
No comments:
Post a Comment