Re: n00b question: Connecting to SQL Server at ISP?

turnstyle (scott@xxxxxxxxxxxxx) writes:
> Hey all, sorry for asking such a grunt question, and thanks in advance
> for any help...
>
> My hosting ISP offers access to their MS-SQL database, and my
> understanding is that it's generally simplest to use some sort of
> client app to do stuff like adding tables and whatnot.
>
> SQL Server includes Enterprise Manager, but since my ISP is running the
> server, I don't need my own copy of SQL Server, just the client.
>
> Any tips? I couldn't seem to find an appropriate download on the
> Microsoft site...

You could download Evaluation Edition. I believe that the tools don't
expire. But you may violate some license that way.

Developer Edition is 49 dollars only. Then again, if this is a production
database, I don't know if the license permits use.

As for creating tables, the best is to run T-SQL script. Then
again, the best tool for this is Query Analyzer, which is among
the SQL Server Tools you are looking for.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

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