New answers tagged

0

The reason I was getting the error message is because I was supplying the scope (dataset) in the wrong place. The scope needs to be supplied as the second argument of the aggregate function. I was incorrrectly supplying the scope as part of the left function (which is not an aggregate function) instead of the SUM function. Below is what the working ...


0

The URL to manage the reports is different than the URL to execute the reports (the RDLs files) You can check it in the Report Configuration. Regards, Martín G


0

I believe you cannot do that. But, I came across something similar answered on the forum already. You can achieve a similar effect by following the steps in the link below. Please go through the below link and check if it might be useful to you. http://stackoverflow.com/a/9503789/2818351 Credits to the original author who answered the question.


0

This simple query on MSDB should get you started: SELECT s2.subsystem AS [TypeOfJobStep]-- when subsystem = 'SSIS' then 'SSIS job step' , s2.command AS [JobStepCommand] , s.name AS [JobName] FROM dbo.sysjobs AS s JOIN dbo.sysjobsteps AS s2 ON s2.job_id = s.job_id You can identify SSRS subscriptions because their name will be alternating ...


12

Will running a large query on a secondary database in an availability group affect transaction performance in the primary database? It depends on the sync mode you have used when configuring Availability group - Sync or Async ! On Secondary replica, all the transactions use Snapshot Isolation level ONLY and all locking hints are ignored as well. That's ...


1

To anyone who cares, Our SQL 2008 instance was not on SP3. After installing SP3 everything looks to have taken care of itself.



Top 50 recent answers are included