Couldn't you do a DELETE with the OUTPUT clause? This will allow you to get the exact records that were deleted.

BOL for OUTPUT clause.

If capturing the deleted record is...

Are you using a where clause based on tab2?

Where clause is applied after the left outer join. This means that the left outer join will return all...

I don't think there is much you can do to fix this. This has to due with how the browser renders the report objects.

One thing I've noticed...

I don't think this is something you can do purely with SSRS.

There's no real way for SSRS to determine if the report is empty or not without running...

Are you using SSIS packages in your jobs? If so, make sure the server does not have any resource contention between the SSIS and SQL services.

I believe someone has...

I would think a better design for something like that is to have two tables.

Table 1. Region table with an integer ID column.

Table 2. ResearchType table with a reference to...

Can you just generate the create role xmla scripts and run them after you deploy changes to the AX cube?

AX 4.0 doesn't provide much administrative support for SSAS.

That seems a bit strange...can you check the collation between the two servers?

I believe a Data-tier application helps maintain the structure of the database by providing a good way to manage the schema but does not store the underlying data itself. ...

Only thing I can find is that SQL 2012 Multi Dimensional supports up to 3 partitions under the Standard license. Are you sure you're not possibly running 2012 Analysis...

You need to make sure the data type of the @Station parameter in your stored procedure is also set as 'tabletype_StationLists ' data type.

This sounds like it may either be a problem in the sub report and how it handles the parameters or the way the parent report is passing in the parameters....

The way Excel pivot table works against SSAS is by sending MDX queries to the SSAS server every time you manipulate the data. (Slice/Dice/Expand/Collapse dimensions) If the customer...

Can you run a SQL trace on the data source? It seems like your connection to the data source is getting dropped and causing the SSAS process to error...

It really depends on the server specs and how both instances are accessed.

Without knowing any details except that the server is running a production SQL instance, I would...