Peter E. Kierstead (3/29/2011)

---

Microsoft says a lot of things about their Command Prompt/DOS emulation environment, some of which is conflicting... From my experience the code presented in my previous post...

I've been on both sides of this. It's a two-way street, and it'll fluctuate on "rules" depending on situations too.

The idea of a plan for the week followed up...

After Delete triggers won't run for an update command, unless there's another trigger that's doing an explicit delete action and the cascading triggers option is turned on.

The inserted and deleted...

jcrawf02 (3/29/2011)

---

So, just had a thought, trying to figure out if it's a good one or not. Camcorder that records 1080p straight to the cloud? Unlimited (assuming unlimited pocketbook) video...

Per the documentation on xp_cmdshell, the advice on using double-quotes may be flawed.

From MSDN (http://msdn.microsoft.com/en-us/library/ms175046(v=SQL.105).aspx):

' command_string '

Is the string that contains a command to be passed to the operating...

You're probably missing the Office 2007 data providers, based on the error.

They can be found at: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

SET has the advantage/disadvantage that any attempt to assign multiple values to the same variable will fail and raise an error.

SELECT has the advantage that you can assign values to...

You can skip the top row in the connection manager. Will that accomplish what you need?

I would avoid the update to the Parents table completely, and drop that column in the table. It would be easier to query the Parents table and calculate status...

Instead of adding a trigger to the table, either add a column to the table that indicates it has been transfered to the other server, or add a log table...

You're welcome.

Try this instead:

ship_to_addr1 +'

' + ship_to_addr2

Yep. Calculate at runtime, unless it's actually necessary for...

It's usually better to handle that kind of formatting in the application/presentation layer, but if you have to do it in the query, it can look like this:

coalesce(

ship_to_addr1 + char(13)...

The recommendations don't change. Apply the SP in dev/test, definitely, but only apply the CUs if they're applicable. With both, test to make sure they don't break anything...