Apparently, Service Broker event notifications can only be scoped to a specific Queue. So change your CREATE Event Notification as follows:

CREATE EVENT NOTIFICATION pmQueueDisabled

ON QUEUE pmNotifyQueue

...

Sorry, I didn't see this before....

Is the comma in CREATE SERVICE a mistake or is there supposed to be another contract? (I am getting a syntax error there).

Glad we could help.

baumgaertner: It has already been explained how to do this with a script, even how to use SSMS to generate this script for you. Please let us know if...

What the Tablly table or CTE does in this case is to give you a way to create a a bunch of Divisions at once. For instance, this example...

The Division numbers that you gave were in sequence which naturally suggests the use of a "Tally" or "Numbers"...

They use what is called "Copyleft". It's all explained at their Copyright page, here: http://en.wikipedia.org/wiki/Wikipedia:Copyrights

Thanks, Jonathan

Could you give me a pointer to an example of how this is done, Jonathan? I think that we are probably talking about different things, but I do...

Actually, I see this as a fairly interesting proposal, particularly as a path-forward starting point for allowing some kind of dynamic querying while preventing injection threats.

The problem is that at...

Jeff Moden (10/9/2008)

---

Heh... I agree......

I have to ask: Why are you using lowercase thorn ("þ") as a column name?

I cannot give you a real detailed answer without DDL's and sample data (see http://www.sqlservercentral.com/articles/Best+Practices/61537/). However the basic query type that you would use in SQL would look like...

DECLARE is a statement. A CTE is an expression. In SQL, expressions are contained within statements, and never the other way around.

Unless you are trying to make a...

My one suggestion would be the same as before: try a more relational approach to this.

Here is an example of how you might do that:

--====== Relational Tables

Create Table Players(

PlayerID...