How do I manage SQL Server?
Max
Server set up with a web site hosting provider? I just need to be able to
add/delete tables. MS Access allows me to export a table to SQL, but it
won't let me edit existing table schemas.
Is Enterprise Manager downloadable?
--
Max
BP Margolin
> Is Enterprise Manager downloadable?
No ... it is supplied as part of SQL Server, and is not an "independent"
utility.
You should be able to use Access and pass-through queries to accomplish
whatever you want on SQL Server.
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"Max" <max...@portvista.com> wrote in message
news:LR3k8.15090$P4.12...@newsread2.prod.itd.earthlink.net...
Max
hoping there was an easier way to create/edit/delete tables...
"BP Margolin" <bpm...@attglobal.net> wrote in message
news:3c90e...@news1.prserv.net...
ITtrainer
You can install the client tools only for MS SQL Server, and if you so
wish include the Enterprise Manager, you are able to create an alias
(using the client network utilities) to your
web server implementation of the SQL Server instance that is hosting
your database (assuming you have all the relevant permissions), and from
here you can
remotely manage your DB as you wish through the EM.
Hope that clears it up... as far as being downloadable, well its
Microsoft so you can always lay your hands on a 120 day eval if you don'
t own a copy of the product.
"Max" <max...@portvista.com> wrote in message
news:45ok8.21370$Vx1.1...@newsread1.prod.itd.earthlink.net...
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
BP Margolin
However, what I posted still stands. It is not downloadable, and, I'm
reasonably sure that in order to use EM you need an appropriate license. One
cannot, as I understand it, for example, **legally** take the EM from the
evaluation version of SQL Server and use that to manage MSDE.
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"ITtrainer" <just...@c4.com> wrote in message
news:1211ff96ccd3e6b3857...@mygate.mailgate.org...
Alejandro Izaguirre
> You are absolutely correct that one can install the client tools only.
> However, what I posted still stands. It is not downloadable, and, I'm
> reasonably sure that in order to use EM you need an appropriate license.
One
> cannot, as I understand it, for example, **legally** take the EM from the
> evaluation version of SQL Server and use that to manage MSDE.
In the case of MSDE, I am sure you are right.
But what about the OP initial question? If the hosting provider has a
per-processor license for his Standard or Enterprise edition, isn't remote
management with EM and QA covered by that license?
--
Alejandro Izaguirre Martín
ale...@terra.es
BP Margolin
In general I try to avoid discussions of Microsoft licensing, because (1)
it's a legal rather than a technical issue, and (2) it can easily become
very complex.
I would strongly suggest that anyone with questions about Microsoft
licensing not accept advice offered on the Internet newsgroups, but ask
official Microsoft representatives and get a full, and, hopefully, accurate
answer via that avenue.
This may sound as if I'm just copping out ... but I really do not want
someone to act on my advice on a legal issue.
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"Alejandro Izaguirre" <ale...@terra.es> wrote in message
news:xoTk8.127424$EH2.4...@telenews.teleline.es...
Greg D. Moore (Strider)
> Alejandro,
>
> In general I try to avoid discussions of Microsoft licensing, because (1)
> it's a legal rather than a technical issue, and (2) it can easily become
> very complex.
>
> I would strongly suggest that anyone with questions about Microsoft
> licensing not accept advice offered on the Internet newsgroups, but ask
> official Microsoft representatives and get a full, and, hopefully,
accurate
> answer via that avenue.
Problem is BP, I've seen Microsoft reps give completely conflicting answers
in the past and both answers have completed with what the license
information appeared to say.
>
> This may sound as if I'm just copping out ... but I really do not want
> someone to act on my advice on a legal issue.
>
Can't blame you there.
BP Margolin
> I've seen Microsoft reps give completely conflicting answers
> in the past and both answers have completed with what the license
> information appeared to say.
You are entirely correct, and thanks for bringing it up. I thought about
including that piece of information in my post, but figured that is a
separate issue ;-)
I suspect that a user has a better shot at avoiding legal entanglements if
they can prove that they were misled by authorized Microsoft personnel. From
a legal standpoint, the only thing that matters is the formal, written
license, and licenses often mention that any information that that conflicts
with the license, even if provided by the company, is null and void.
Nevertheless, I suspect that both Microsoft and a court would look a lot
more "leniently" on someone who took steps to try to comply, but was misled
by Microsoft personnel. I'm not so sure that either Microsoft or a court
would be so inclined if someone acted on the advice from a posting on a
newsgroup.
BPM
"Greg D. Moore (Strider)" <moo...@greenms.com> wrote in message
news:1g5l8.133358$V15.22...@typhoon.nyroc.rr.com...
Leythos
> Alejandro,
>
> In general I try to avoid discussions of Microsoft licensing, because (1)
> it's a legal rather than a technical issue, and (2) it can easily become
> very complex.
>
> I would strongly suggest that anyone with questions about Microsoft
> licensing not accept advice offered on the Internet newsgroups, but ask
> official Microsoft representatives and get a full, and, hopefully, accurate
> answer via that avenue.
>
> This may sound as if I'm just copping out ... but I really do not want
> someone to act on my advice on a legal issue.
>
> -------------------------------------------
> BP Margolin
BP - I hate to tell everyone this, but even MS can't answer questions
about licensing without several days to get the answer.
I work on the same floor as the regional office in my state - it takes
them about two days to determine licensing issues in most cases, longer
if the "one" person they have access to can't be available. I always get
the question and answer in writing so that MS Can't blame me for their
own mistakes.
I called Redmond about 6 months ago to ask about MSDN Universal
Licensing, they told me that if I needed answers about licensing, that I
should contact a corporate lawyer and get the answers - what a joke!
So, to make sure that I fall within license requirements, I always buy a
few extra ones to cover my a$$.
Mark
--
--
Leyth...@columbus.rr.com
(Remove 999 to reply to me)
Michael Bourgon
> Well ya, pass-through queries can be coded in an ASP page too... I was
> hoping there was an easier way to create/edit/delete tables...
Take a look at some of the SQL Server web sites. I've seen some tools
that look like they'd do the job.
Max
queries.
It's a shame Microsoft tools are so expensive for developers. I can't afford
to buy all the Microsoft, Macromedia, and Adobe products and be profitable
doing business with small businesses. It's not that my rates are too low,
it's just that I'm competing with Joe Blow who is doing the same thing with
his pirated copies.
-M
"Michael Bourgon" <michael...@yahoo.com> wrote in message
news:3c093c17.0203...@posting.google.com...
Jim
As MS only accommodate bigger budget developers, they are loosing a lot of
customers, because people are using Unix, Apache, PHP and MySQL instead of
Windows, IIS, ASP and MS SQL Server.
"Max" <max...@portvista.com> wrote in message
news:Zczm8.3122$Tk.2...@newsread1.prod.itd.earthlink.net...