Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)

Pete d'Oronzio [pdmagic] wrote:
Bob Barrows [MVP] wrote:

Pete d'Oronzio [pdmagic] wrote:
Bob Barrows [MVP] wrote:

I'll test SP4. However, my app is a commercial app that runs
against many different databases. I don't get to spec that. I
think I could insist that SQL 2000 instances must be fully up to
date, but I can't required 2005.

One of my fellow mvps tested with SP4 and got correct results, so
it appears all that is needed is requiring SQL2000 to be up-to-date.

Fantastic! I'll try that on mine and see how it works.

Any chance you know how to test the SP level from code?

Thanks!

Just do a "select @@version" and compare the result to this chart:
http://www.aspfaq.com/sql2000Builds.asp

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
    ... I'll test SP4. ... my app is a commercial app that runs against ... all that is needed is requiring SQL2000 to be up-to-date. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
    ... Bob Barrows [MVP] wrote: ... I'll test SP4. ... my app is a commercial app that runs ... it appears all that is needed is requiring SQL2000 to be up-to-date. ...
    (microsoft.public.data.ado)