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...
thanks again, -Scott 4 1425
turnstyle (sc***@turnstyl e.com) 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, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
So there isn't an authorized way to simply download the client tools in
order to connect to a properly licensed server?
1) Does anybody here know if Evaluation Edition tools expire?
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?
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?
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?
thanks again & sorry for so many questions...
-Scott
turnstyle (sc***@turnstyl e.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, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
Am 29 Jul 2005 03:28:11 -0700 schrieb turnstyle: So there isn't an authorized way to simply download the client tools in order to connect to a properly licensed server?
1) Does anybody here know if Evaluation Edition tools expire?
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?
For managing SQL-Server there is a nice free Tool here: http://sqlmanager.net/products/mssql/manager/
look for the Lite version.
bye,
Helmut This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: MiKeY |
last post by:
I am connecting through EM to another SQL server for my web
site, is there a way to limit it so that I only see my database and
not all the 100's of others that are listed.
Also, sorry if this sounds dumb but I applied the sp3 sevice
pack and I dont know how to verify this, normallly one would go to
help>about and see it there, there was a sp3 and a sp3a, but a
friend told me to only apply the sp3, needless to say it seems slow...
|
by: Anupam Kapoor |
last post by:
hi all,
a python n00b, so please bear with me. i have a simple question:
i generally name python sources as a-simple-python-example.py. when i
try to import a module named as above, i (obviously) get tracebacks
from python interpreter.
is there a way to continue naming python sources as above, and still
use it as python modules ? i can ofcourse change the name to
|
by: CT |
last post by:
Hi,
This might seem like a basic question but I have some doubts, please
humour me.
I have a client-server application using java where each client on
each machine needs to directly communicate directly with the database.
Do I need a separate db2 connect on each such machine.
Please advice.
|
by: DB2 |
last post by:
Hello, everyone.
Our developers are wondering if their swing Java-based application
connecting to a DB2 server through JDBC requires the DB2 client access
license (CAL) per user.
They've got the Java app installed on PCs connecting a DB2 server.
They believe that the above scenario does not requires DB2 CALs.
I think as long as an application connects to a DB2 server requires a
|
by: newgenre |
last post by:
I am using a pre-built package of code for my site, which is called
EasyDisc. All it does is it creates an interactive forum on your site, like
any forum you see anywhere.
I am having a problem getting started as I am new to .NET and sql. The app,
once unzipped, tells me to "Make note of your SQL server name, username,
password, database name. You need to supply these info. later."
My problem is I don't know where to find out that info....
| |
by: Ambush |
last post by:
I'm pretty new to ASP.NET programming and web programming in general,
but I've been a client/server programmer for several years now (which
is definately making things more difficult for me). I've got a project
developed in ASP.NET designed, for the most part, the way that I would
design a client/server app. As light a front end as I can make, and
the real workhorse code in the back end. What I'm running in to is
that sometimes (and I...
|
by: JV |
last post by:
I'm trying to understand how ASP.NET creates web folders when it creates a
new ASP.NET project. I am experienced with DotNet development, but not an
expert on how IIS works. Or, this may be a question about FP Server
Extensions.....
When you create a web project in the default way, VS.NET has no trouble
browsing for files. However, I like to keep all of my projects under a
folder structure like C:\PROJECTS\ with a subfolder for each...
|
by: Ann Marinas |
last post by:
Hi all,
I would like to ask for some help regarding separating the asp.net
webserver and the sql server.
I have created an asp.net application for a certain company. Initially,
we installed both the iis and sql server in a single machine. Not too
long ago, the machine had some hardware problems, and management has
decided to purchase new servers, for both asp.net and sql server.
|
by: rtlshred |
last post by:
Hello
I have just, just started C++ programing. the complier I am using is Dev C++
Here is my question:
Once I have written some code, How do I run the program and see the output?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |