You need to set the data source to run using a SQL account to make the report access the DB using a SQL login.

Access to the SSRS web page is...

The only thing really would be to check the steps.

You could query msdb.dbo.sysjobsteps, but that will only tell you the DB which is in the step screen, it wont tell...

Quickest answer is you cannot, data driven subscriptions are an Enterprise only feature.

Do you have a backups of Master before the database became corrupted?

Unsure on the way that MS's brain works, but I would be guessing that if they think that if the user has scripted the DROP and CREATE from within Object...

Right so just did exactly the same again, but in 2012 is seems like they dont wrap the drop or create in IF EXISTS commands, and just does the ALTER...

So far I believe it is only an issue on default constraints, as when you script a table for drop and create it picks up the schema of the table.

I...

There is a rouge comma in the SQL which you supplied on the first post at the end of the TotalSales word, should be able to remove that and it...

Yep, noticed the type column while investigating it, always thought the two view where different in that way, obiously not.

It is down to the schema which is why it wouldn't...

Looks like an easy mistake, but you have [ ] around the object name in the IF EXISTS.

Scrap that it does work with [ ] brackets, in the object_id...

Again same rule applies, it is a service running on the windows box, so you need the correct rights to stop/start/restart services at the OS level.

And how did you come up with that it would use the DeptID index and not one of the others?

Is this homework, interview questions?

Nest the two statements as derived subqueries and add a joining criteria, then join the two together like below

SELECT

T1.[Total Sales £],

T2.[Total Uninvoiced £]

FROM

(

SELECT

1 AS ID,

Sum(TotalSales) as 'Total Sales £' FROM...

Hi, welcome to SSC

Your post is a little vague and we will need a lot more detail than that, there could be 1million and 1 things that need looking at.

Take...