How about we get things like attachments on the articles fixed first?  That and continue to "fix the internet".  I've come across many links in Google to posts on SSC...

Or create a third job that calls a new proc that calls the stored procedures that you're using in the other two jobs.

Heh... yeah.. me too.  I hate SSIS. 😀 😀 😀

Totally agreed... write a good stored...

Look at the progress we've got in SQL over the years! what used to be 13 years ago a short inline formula using system functions and integer arithmetic is...

It would be interesting to see what the backlogged items are and the expected fix release date.

I guess the real key here is that if you're dividing by zero, there's something wrong with your data, your code, or both.  I've never ignored divide by zero errors...

Now that you have an answer, do you know how it works and why it could fail?

Just ran across this.  Yeah... you file path has spaces in it, as well, and so it needed to be quoted.  I got into the habit of automatically encapsulate such...

Have you ever encountered some code that makes you feel that you need wine instead of coffee to fix it? Or is it just me?

I'm working on a code...

I had similar issues and the single user thing seemed to handle that.  You DO have to be careful to not lose the single user connection or those service logins...

Heh... there must be a disturbance in the force.  I've been asked to do something similar about 2 weeks ago.  Because I have to kill a bunch of data and...

While that's incredibly simple, as it was designed to be, FORMAT has been tested and documented as being 44 times slower than even poor renditions.  Until...

Warthog

I'm not sure how any of that was misleading.  I did state that the 8096 included the row header and did state that SQL Server uses the number 8060 for...

There's a difference (to me, anyway) between a table that suffers a whole lot of INSERTs and a table that suffers UPDATEs.  Run logs (with only one exception...