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...

The writing of the page from memory to disk.

All writes happen in memory, then internal processes within SQL take the written to pages from memory and push them to disk.

Logical is anything to do with memory, so a logical write is writing to the page in memory.

No they are two completly different indexes, one will work if you only ever search on the ID but want to show CH, NA in the result set the other...

But you wanted to list logins which dont have a role assigned to them, which is why they are null.

This query does not list logins which are not assigned any...