Viewing 15 posts - 3,061 through 3,075 (of 5,685 total)
The Dixie Flatline (6/2/2011)
Msg 4104, Level 16, State 1, Line 10
The multi-part identifier "f.id" could...
June 2, 2011 at 3:44 pm
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...
June 2, 2011 at 3:37 pm
The Dixie Flatline (6/2/2011)
Yet again, I will attempt to explain....
ROFL...
... anyone here know how to Madison?
June 2, 2011 at 3:35 pm
The Dixie Flatline (6/2/2011)
Where is the join to F in either query? What are using to join to C...
June 2, 2011 at 3:30 pm
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...
June 2, 2011 at 3:24 pm
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.
June 2, 2011 at 12:21 pm
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...
June 2, 2011 at 12:19 pm
jd_ajy (6/1/2011)
Please I need comments. Thank you.
I ... think I kind of understand what you're trying to do, but can't quite wrap my head around it.
As mentioned above,...
June 2, 2011 at 12:14 pm
It's simply not supported:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319138
June 1, 2011 at 5:27 pm
david.holley (6/1/2011)
June 1, 2011 at 5:25 pm
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....
June 1, 2011 at 3:01 pm
WayneS (6/1/2011)
Lordy, I knew 2005 made it easier... forgot just how much easier! I'm having trouble even thinking along those lines anymore. 🙂
You'd laugh to know I built one of...
June 1, 2011 at 2:52 pm
jcrawf02 (6/1/2011)
The Dixie Flatline (6/1/2011)
SOM
Somebody remembered!
LASHIWAB!
:unsure: :alien:
June 1, 2011 at 2:46 pm
david.holley (6/1/2011)
June 1, 2011 at 2:45 pm
james.morrison 19355 (6/1/2011)
Craig Farrell (6/1/2011)
:rolleyes: Interesting choice of words. Master, or have enough to get by with?
If you are referring to the MCM in terms of "Master" then...
June 1, 2011 at 2:43 pm
Viewing 15 posts - 3,061 through 3,075 (of 5,685 total)