The Dixie Flatline (6/2/2011)

---

Craig, I created tables A-F in my sandbox database and the queries posted would not run.

Msg 4104, Level 16, State 1, Line 10

The multi-part identifier "f.id" could...

The main script and the event handlers can't share variables if you open them for read/write through the interface.

Look into LockForOneRead and LockForOneWrite. My guess is this is where...

ROFL...

... anyone here know how to Madison?

The Dixie Flatline (6/2/2011)

---

Are you sure about your syntax?

Where is the join to F in either query? What are using to join to C...

It's a syntactical way to represent subquerying.

The basic gist is do you inner join the entire left join first, thus restricting what gets left joined, or perform the left join...

Or use multiple OLEDB sources to call each proc/database/whatnot, and then use the union operator (it doesn't stall the stream) to a single delivery point.

Alan,

What you're describing is what I've always known as a data flow diagram. They are very powerful but you can't keep them up to date forever, the documentation on...

I ... think I kind of understand what you're trying to do, but can't quite wrap my head around it.

As mentioned above,...

It's simply not supported:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319138

david.holley (6/1/2011)

---

My limited knowledge of SQL Server security somewhat grasps that concept given impersonation with ASP.NET. So I believe I understand the concept that doesn't matter who in the parent...

The Trigger would need to go through a linked server that way. Let the linked server impersonate a valid user on the foreign DB. That's the quick fix....

You'd laugh to know I built one of...

:unsure: :alien:

david.holley (6/1/2011)

---

So I'm assuming that the records that exist in the parent DB can simply overwrite their counterparts in the child DB leaving any records unique to the child DB...

james.morrison 19355 (6/1/2011)

---

If you are referring to the MCM in terms of "Master" then...