Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)

Bob Barrows [MVP] wrote:

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

Hmm.. That select @@version is handy to look at, but not much for
coding against. I don't imagine the format is defined and will be
consistant.

Turns out several of my clients aren't running SP4, and don't want to
update badly. I'm going to try a ADOX, or workaround.

Thanks for all your help. It's at least good to know this is a bug
in SQL Server.

-Pete
.

Relevant Pages

  • 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)
  • Re: Service Pack question
    ... That shouldn't stop Microsoft from listing SP4 together with all the ... -- torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway Administration scripting examples and an ONLINE version of the 1328 page Scripting Guide: ...
    (microsoft.public.win2000.general)
  • Re: Bitte Testen: Änderungen verfolgen
    ... Helmut Weber, MVP ... Word 2002, Windows 2000, SP4 ...
    (microsoft.public.de.word.vba)
  • Re: Windows Messenger to my Win 2000 PC
    ... since I don't want to install the requirements for the last version? ... As for SP4, it is required for all versions of WM to run on Win2000. ... FAQ Messenger & Netmeeting: http://www.uni-essen.de/kitt/faq-nm.htm Tschuess, regards, salut, Thomas Bliesener, MVP http://tinyurl.com/rqed ...
    (microsoft.public.windowsxp.messenger)
  • Re: File version check built-in Microsoft security patches/Service Pac
    ... "Torgeir Bakken (MVP)" wrote in message ... > frisak wrote: ... Will they be overwritten by sp4 ... after the upgrade ...
    (microsoft.public.security)