Thanks Venoym. I admit, I had forgotten that, if I'd ever known it. So, I've learned a good amount here as well. 🙂

Anybody with a solid level of experience in Service Broker able to help someone out? He's new to the site but he's definitely providing what we need and is...

So you're definately not losing them due to communication loss or...

Thus causing duplication, which you're trying to avoid, so you need a way to have each line have a connection to all the other lines but in a unique way....

Lynn Pettis (8/28/2014)

---

I really must be getting jaded. I get chastised for not being able to figure out what some ones uncommented and convoluted code on a blog does,...

So extrapolate on Eirikur's code for all the rest of the tables. If you don't understand the example he provided, we can walk you through it. However, there's...

Just to confirm what Luis said... no, you can't. The Port is how it communicates and knows what belongs to it, everything else is an alias.

Why would you want...

Just doublechecking. I've seen odd uses of things before and I hate making assumptions, so I tend to ask a lot of clarifying questions. Saves time in the...

The name is dimension information. Your reference table can be most easily found through the sys views:

SELECT * FROM sys.indexes

select * from sys.index_columns

You'll notice it stores the column_id, locatable...

Check to make sure your schema information is matching. I usually see that happen when I forget to slap dbo. onto the table name in the create. My...

Is this in Service Broker? That's usually when I see that WAITFOR construct.

I have personally found that indexing a #temp table to have similar indexes to what else I'm joining it to generally stabilizes and improves my query plans. Like most...

SQLTestUser (8/26/2014)

---

Thanks for the quick response, it is for a database server which is hosted but managed internally as of now, and signs are pointing towards giving full control to...

Two questions and a clarification:

Clarification: What are you using to build the @sql string? Is this completely encapsulated in an OLEDB or Exectute SQL task, or are you assembling...

Oh, he's been around a while. He stopped at one point. I'd hoped they'd shut his account off.

*sigh* What...