Bummer! :crying:

Heh, all things considered, I would rather not have my low-end monitored.

😀

Um, what are you actually trying to do? Maybe a small example of what results you want.

Thanks, Steve

As I understand the Welcome Reception will be a 6pm on Tuesday. When and where will the Casino party be?

Adam Hardy (11/12/2008)

---

Where I'm at now is I've got everything working except for the pesky error that gets thrown when a stored procedure exits with a different trancount to when...

3GB does not sound like anywhere near enough memory for 1000 databases.

smunson (11/12/2008)

---

Just out of curiousity, could the sproc "store" the current state in a table somewhere, with enough detail to avoid having to leave the transaction open, such that subsequent...

And no matter what you do, it will definitely still be UNSAFE.

Hmm, I...

I wasn't aware that there was a difference between "!=" and "<>"?

Not much: the builtin scalar functions are generally very efficient per row, especially when compared to the cost of data retrieval per row.

Right, sorry forgot about this restriction of Access:

SELECT DISTINCT (

SELECT COUNT (Lesson_CatId)

FROM Session_Information, Lesson_DateSchedule

WHERE Lesson_CatId = "001" OR Lesson_CatId ="003" OR Lesson_CatId = "004" ...

Right, but counting on that...

Nah, just one of the usual suspects.