I wasn't sure if your set rowcount was referring to my post or not, but a trigger testing @@rowcount against all records in table will catch & prohibit all statements...

Yes, that was my thought too (as to my problem), but such is not the case.  However, over today's readings and musings, I've concluded that OPENROWSET[BULK] and placing the data...

Setting aside all of the high-level advice you will get (most / all of which you probably already know, but it's out of your control), I have used one specific...

Scott, did you ever get a solution to this somewhere? 
I was very curious on your post, I am new to the forum and had some XML trouble too.  Given...

Hi, thanks for helping me out.  It's true, I did allow SSIS to generate an XSD file, from which it then reads.  Before doing this task, I researched for a...