Sounds like you're due a vist from a consultant with his Swiss Army diagnostic tool kit.

Do you have any jobs running in SQL Agent that might be looping?

Tables growing?

Viruses?

Are you...

Then I salute you as a fellow thief and master plagiarizer. I'm still modifying code I stole years ago. I don't think any new code is being written...

quote:

---

I do not trust sysindexes row value.

---

The value in sysindexes comes from the "update...

quote:

---

Also, keep in mind if you use a clustered SQL Server support on the MDAC has been broken since 2.5 (you thin...

quote:

---

Server is three floors up (connection 100meg).

---

If you have physical access to the server, run...

Your poor overworked SQL server got fed up with handling the 1000's of unsolicited reqeusts and decided to throw a fit until you gave it some personal attention.

No wait a...

quote:

---

Don't get why 'with nocheck' is needed when data in the table is coherent with the check, but I can live with...

MDAC 2.7. Why put off 'til tomorrow what you can upgrade today? Reboot once instead of twice. Come in on one saturday instead of 2. Need more?

Try...

You forgot to mention you already have data in your table, didn't you? Your check constraint is validating the data when you try to add it. add with...

I bow to the master guru for a much simpler and more elegant solution.

If your server is physically remote from your location, you may actually be experiencing timeouts due to slow networking connection, congestion or the other usual suspects. Try increasing the...

Boy this seems to be the question of the day today. You can define your foreign server as a linked server and use 4-part names to select from tables/views.

Or...

quote:

---

Question: I heard that MDAC 3.0 is out but I think that 2.7 is the latest. Please comment.

---

December 4, 2002 at 12:31 pm