@ Jack, Your query worked perfectly on the 2000 db. Thank you.

@ opc.three, I'll try your Schema method. Thank you.

@ Lutz, I agree, but those decisions are above...

Mr. Lutz,

Your query worked perfectly on my 2005 db. Thanks.

@everyone, any help with getting this info from my 2000 db would be appreciated. If I need to re-post...

Now I feel rather silly.

The db that we are migrating into is 2005. The old db, the one that I'm trying to get the information from is 2000. ...

Hi Lutz,

I'm executing it with Query Analyzer.

Thanks.

Dave

Lutz and ColdCoffee,

Thank you for replying.

Unfortunately, Lutz's query returns this:

"[Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error"

Thank you.

Dave

The article mentions "client-based test harnesses that can simulate real usage". Does anyone have any recommendations for information on developing client-based testing methods? Maybe something automated?

This...

Paul White NZ (4/7/2010)

---

David Fulton-420388 (4/7/2010)

---

Paul White NZ (4/7/2010)

---

David Fulton-420388 (4/7/2010)

---

I'm in the camp that the DBA should maintain the data entered by the users. If data looks incorrect,...

Paul White NZ (4/7/2010)

---

David Fulton-420388 (4/7/2010)

---

I'm in the camp that the DBA should maintain the data entered by the users. If data looks incorrect, then bring it to the...

I'm in the camp that the DBA should maintain the data entered by the users. If data looks incorrect, then bring it to the users' attention and let them...

I want to especially encourage anyone who is CMV Negative to give as often as you can.

FYI a large portion of the adult population (at least in the...

Hi James,

I don't think it's...

GSquared (6/5/2009)

---

David Fulton (6/5/2009)

---

In my experience, companies generally invest the most resources (tools, salaries, etc.) in the high-profile, risk taking, "generators" who's contribution to the bottom line is easily quantifiable....

This is compounded by the...

I am relatively new to IT, so my opinion is more from other areas and you may want to take it with a grain of salt. However, I think...

Assuming that weather and personal obligations permit, it's fly fishing a local stream, or sipping whiskey and/or beer with friends while something cooks on the grill. 😎 Maybe even...