RBarryYoung (2/10/2010)

---

Yeah, there's just something about feeling like I have a screwdriver jammed up my spine that...

Yeah, there's just something about feeling like I have a screwdriver jammed up my spine that makes...

BaldingLoopMan (2/9/2010)

---

...

Lynn, do you feel you should apologize as well for flying off the handle and holding the services you provide over someone’s head until they conform to your professional...

Smackdown: http://www.sqlservercentral.com/Forums/Topic851938-1281-1.aspx?Update=1

Someone tried to pimp-slap me with a performance benchmark. Big mistake.

I did. three years ago when Remus wrote it.

It shows quite clearly that cursors are much faster in this instance than...

ALZ, sorry I took so long to get back to you...

Anyway, I took a look at this and although 50/logins a second is a lot, the Queue itself should be...

j.a.c (2/9/2010)

---

It seems that you could change your activation proc to use a cursor or since you are not sending any messages back (nor ending the conversation) you could even...

Ed-86789 (2/10/2010)

---

When I needed to delete a million plus rows of out-dated data I used SET ROWCOUNT {some number} to limit the number of rows affected with each batch so...

Tom.Thomson (2/10/2010)

---

...There just isn't any way (that I've found) inside T-SQL of reading multiple rowsets returned by a stored procedure; multiple result sets can be passed from one SP through...

tendayit (2/10/2010)

---

Hi,

Thanks for the help. I now know what to do in future. I have attached the missing tables and some sample data. I took a 100 accounts for the...

Or alternatively just set the owner of the database to 'sa'.

Do what it says.

RBarryYoung (2/9/2010)

---

Bob Hovious (2/9/2010)

---

Crap! My wife...

You will need to set the source database to TRUSTWORTHY. Note that doing so has security implications.

As a side note, when I was learning Service Broker a couple of years ago, I read over thirty articles, tutorials and walkthroughs, including many from Microsoft. And yet...