It's good to hear that you're making progress. Let us know if you need anything else.

L' Eomot Inversé (11/29/2012)

---

Basically, I reckon he's doing no, or almost no, connection re-use within his app, and pushing connections up and down faster than teh server can cope with...

How is your environment set up?

For instance, in one environment I worked on, we had a SQL Server, a Citrix Terminal Server, and an application / file server. I worked...

pdanes (11/29/2012)

---

I just looked at the logs again. There is nothing in the application log from that time period (literally nothing, at all). The system log has several remarks about...

FYI: I think this...

Before you ask any more questions, or post any more threads, you really need to read the book everyone has been referring you to. Then ask questions after you've worked...

GilaMonster (11/28/2012)

---

One thing that's important to note is that the query processor is a pipeline. It does not execute each operator one by one on the entire resultset, so, in...

So you can't find any events that indicate the SQL Server services shut down, recycled, or that a connection got dropped *before* you got the error posted in your OP?

And...

Hey, all. Anyone have any experience with MS Access applications (adps, etc.) that use SQL Server as a back end?

I have experience on the SQL side, but a lot of...

Which is what I said in my initial reply. @=)

no disrespect but...

And now back to the non-technical portion of The Thread...

Has anyone had one of those days where you look at your inbox and you realize your entire day has been...

Revenant (11/28/2012)

---

Brandie Tarvin (11/28/2012)

---

I'm going to do a horrible thing and ask a technical...

I'm going to do a horrible thing and ask a technical question prompted by...

"replace" is a poor choice of words here. When...

pdanes, have you checked your connection pooling properties both in the app and on the server to make sure you can reuse existing connections and that the pool isn't throttled...