have you checked the execution plan for the query to see if anything stands out

when you created the r2 profile did you have ssms connected to multiple servers?. You might have opened the wrong servers mail config wizard hence why its showing on the...

you could set the database to off-line / read-only after the restore which will stop the users logging in.

then set the database to single user, then read-write and run in...

develop drill down reports.

basically in my solution I'm working on at the moment it gives high level information first, then you click on a particular metric and it loads a...

just use ssrs in native mode and develop the reports as normal which show the kpi info you want to show

I'm designing a monitoring metrics dashboard zt the moment which...

are you restoring through script? If so do you have operators and dbmail configured? You could but a send mail or notify operator tax command after the restore to email...

you should be able to configure that in the app where it grabs to logged in user at launch and stores it while the app is open then passes it...

to summarise on from the link that dskinner provided

the two accounts nt service\mssqlserver and sqlserveragent act as a sort of proxy

it allows you to change the service account as and...

the company I work for now uses entity framework, its managed by using windows auth on the connection string for only the account running iis. This user cannot login via...

nope, it is a pain staking process to go through and change the security. That is why you see so many people talking about security groups in ad which...

domain accounts and groups are two different things,

the objects to which the user cannot see will not be set at home level security. You will need to go...

easiest option would be to get your ssrs admins to give you report builder access that way you can modify them direct on the server.

if that's not an option there...

did you open the report in report builder which is the bottom option when you use the drop down menu when you hover over the report item?

or did you save...

take a look here, this is the proc we use to send out any job failures

http://www.sqlmag.com/article/tsql3/have-sql-server-email-you-error-messages-generated-by-job-failures

I've done something similar, just created a blank report the way i want it then copy and pasting the XML code from the tamplate into a new blank rdl for...