Wednesday, May 21, 2008

Scheduling a SSAS backup on SQL Server 2005

Today I had a requirement to schedule a backup on SQL Server Analysis Services. Here is the link that I found very useful for me. SSIS package to backup SSAS databases

No comments:

INSERT EXEC failed because the stored procedure altered the schema of the target table.

This morning I was trying to call a stored procedure and insert the results in a temp table using the following code  -- create table #...