Because GO separates code into batches and SQL parses and executes batches separately.

A batch is a set of commands sent to a server. Hence, if you run this:

CREATE PROCEDURE...

You can get the same message with a differential. I've seen it before when a full was made one way (native backup) and the diff was run with something else...

Developer edition is the equivalent of Enterprise edition in terms of features, but it is licensed for non-production usage only. You may not use it for production systems at all.

If...

Look at the red underline in the very first line of the script that you posted. It's pointing to exactly what the problem is.

Look at the very first red underline in that screen shot (on the very first line), that's your problem.

Is the instance running with any trace flags enabled? Are row or page locks disabled on the index?

Yup, and it's about the only practical way of doing this.

.

Define a parameter, or pass a parameter? Since you do both in your first post, I don't understand why you're asking.

Quote from your very first post (parameter definition in bold).

CREATE...

Where's the parameter?

Sure.

http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7279

I got to inequalities around half way through.

Nope, completely...

10GB for SQL 2008 R2 and later. 64bit vs 32 bit...

Ok, so to confirm:

You need to be able to add views and tables to the reporting database

You don't need to change existing tables (tables from the primary)

You don't need to...

TheSQLGuru (10/15/2014)

---

And many (most?!?) SQL Server users still have little to now experience with XEvents or the XML stuff you need to mess with to make use of them....