Do you have a "GO" between the first and second steps of the first job? If not, try putting one in.

(Also a guess)

In QA, the number of current connections is shown in the lower right hand corner.

You might have an asp page somewhere that opens a connection and doesn't close it. Eventually you get too many connections and can't open any more. Of course...

Do the bulk insert first. You can bulk import to a staging table. If the bulk insert fails because of dirty data, the rest of the stuff won't...

I second your interest. I consider myself to be in much the same boat...a wearer of many hats who would like to focus on a career path as a...

It's not really the way check constraints were meant to be used, but I think you could do it by creating a UDF that performs the logic of checking all...

This would mean basically changing the MIDI file specs, even if you still use the original specs for individual MIDI messages. Do that, and all the old MIDI-gear would...

Another editor that is similar to EditPlus, and way more powerful is HomeSite. It isn't free, but it's only around $60 (last I checked).

An example of one...

quote:

---

but as long as new rows are inserted into tShortTerm sequentially by date then you should add an identity column to tShortTerm...

quote:

---

In most cases, Index selection is based on SARGs

which is determined by your [WHERE] clause.

---

Forgive...