What about the transaction log? I have worked in an environment where disk space was hard to come by. I had a similar need, but I also had...

One thing I found with TVPs is that they cannot be passed over a linked server :(. It was the only time I needed it and I too had...

Dah, thanks Ben. Sorry about that. What he was doing was passing in the condition through a variable. Here is the refined example.

declare @Foo as...

For those of us who saw the extra union all and took it out, is the correct answer 3 then (0,1,2)? I ran it like everyone else and thought,...

This worked for me on Windows 7, but it did not work on my Server 2008 R2 box. Anyone else having this issue there?

I see I am not the only one who noticed the extra comma. Did the author plan for this to throw people off??

When we were testing before, we were just scheduling the job so it was a similar scenario. Sorry, I should have mentioned that.

Tried a different approach. Set the...

Sounds like a lot of extra work. Why not just setup a log file on the job step advanced tab. Takes two seconds and will provide any error...