Posted by Erland Sommarskog on 07/29/05 18:40

turnstyle (scott@turnstyle.com) writes:
> So there isn't an authorized way to simply download the client tools in
> order to connect to a properly licensed server?

No, I don't think so. But I've directed a question on my Microsoft contacts
to see what the exact status is.

> 2) Another option seems to be Aqua Data Studio
> (http://www.aquafold.com) -- should I use something like that, or stick
> with Enterprise Manager and its Query Tool?

I can comment on any third party tools, as I have not use them. But
indeed that may be the only option.

> 3) I think I have a copy of SQL-7 somewhere, I suppose I could use that
> client, but are the client tools now much better with 2000?

I would expect Query Analyzer from SQL 7 to be able to connect, although
it would be able to handle bigint and sql_variant columns correctly. As
I recall QA in SQL 7 was quite a bleak tool; had I at the time had reason to
work with SQL 7, I would probably have stuck to the 6.5 tools. (As it
turned out, we went directly to SQL 2000.)

EM 7 may be barred from access altogether, but you could always try.
Again, bigint and sql_variant, will not make a huge success. I
can't comment on how much better EM 2000 is than EM 7, but I can't
say I'm overly excited over EM 2000.

> 4) Sorry, one last question -- I actually *tried* to purchase an
> upgrade from SQL-7 to SQL-2000 but I couldn't figure out what I was
> supposed to get -- any tips on how to actually do that?

I guess you would get the edition of SQL 2000 that matches your SQL 7
license. If that's a developer license, I would not expect that there
are any special upgrades available today, since DevEdition been slashed
to 50 USD.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]