what were those processes doing when they were "waiting for Service Broker"? And how did you determine that they were waiting for Service Broker?

Okey dokey

Your function misses those cases where the requested time range surrounds (or "Spans") an existing one. For example, let say that the only time range in your table for...

GSquared (6/5/2008)

---

Try this, see if it doesn't speed up the query a bit:

;with

CTE_CreateTime (ConID, Created) as

(select conid, max(createddatetime)

from Ex

group by conid),

CTE_SID (ConID, Created, [SID]) as

(select ex.conid, ex.createddatetime, max([sid])

from Ex

inner...

"SET QUOTED_IDENTIFIER OFF" works fine for me. What...

Glad we could help.

Actually, the only thing that I see wrong with your query is that you are using GROUP BY in your subSelects when you do not need to.

Your problem is with your connection string, NOT your SQL commands (though I think that there are some problems there too).

Connection String:

You Initial DB (or "Catalog") is 'netGuest',...

Can you create any other Jobs or job steps?

ben schwartz` (6/4/2008)

---

1st if SSCommitted (RBarryYoung) reads this... thank you for your answer to my last post... you were 100% correct....i saw the "he session keys for this conversation...

Heh. thanks, I think.

You know, what's really wierd is that there is NO physical update operator in the ShowPlan, only the logical update operator.

Please generate a script for table ats_CampaignClient, including all options.

Thanks for the feedback!

This is failing when you create the USERs, not when you are creatign the LOGIN. The USER create is failing for exactly the reason that the error message states:...