Since I'm one of the organizers, live in the area, and missed the Summit, I'll be at SQLRally.

Evan is doing okay, but is in a lot of pain still. Hoping to bring him home this evening, but may not be able to because of his pain.

Alice...

LutzM (11/5/2010)

---

Jack Corbett (11/5/2010)

---

...

Diagnosis is in. Displaced fracture about 2 inches below the elbow which requires surgery to be set properly. Local ortho doesn't do kids (which makes...

WayneS (11/5/2010)

---

Jack Corbett (11/5/2010)

---

Diagnosis is in. Displaced fracture about 2 inches below the elbow which requires surgery to be set properly. Local ortho doesn't do kids (which makes...

tosscrosby (11/5/2010)

---

ALZDBA (11/5/2010)

---

Jack Corbett (11/5/2010)

---

Today my oldest son (9) fell off a swing, landed wrong on his arm and is on the way to the ER with his...

Roy Ernest (11/5/2010)

---

Ah Crap and double crap. Hurricane Tomas is threatening again. It is turning to the east and the tail is once again coming over the island. Why cant...

Today my oldest son (9) fell off a swing, landed wrong on his arm and is on the way to the ER with his mother because I'm pretty sure he...

Service Broker may be a more difficult initial setup, especially with a learning curve, but it is designed for this sort of thing.

I have not yet implemented a solution...

I have no idea how long it will take to create the index(es) but if you are low on space then that could be causing some of the issues. ...

I think you should look into Service Broker. This sounds like a classic case for it.

You could do it like this:

Source -> Lookup Component to check if product exists -> Yes then pass row through with the ProductID added to the flow -> Destination -...

As Gus said, it is a double-hop or multiple-hop issue which means you need to use Kerberos delegation in order to use trusted authentication with OPENROWSET.

Check out the...

Completely untested, but something like this could work:

SELECT

*

FROM

Person.Contact AS C JOIN

HumanResources.Employee AS E

...

Agree with Gus. Check out this article[/url].

Sounds like a Kerberos issue because of a double-hop authentication. Check out this article[/url].