Can anyone tell me if the SQL Server Agent is included with MSDE? I realize
that Query Analyzer and Enterprise Manager are not included. I intend to use
MSDE for a project and would like to create jobs that will get scheduled by
SQL Server Agent.
Thanks.
Yes, Agent is included.
Andrew J. Kelly SQL MVP
"Amos Soma" <amos_j_soma@.y_a_hoo.com> wrote in message
news:jMqdnVEia9dLsULdRVn-vA@.buckeye-express.com...
> Can anyone tell me if the SQL Server Agent is included with MSDE? I
realize
> that Query Analyzer and Enterprise Manager are not included. I intend to
use
> MSDE for a project and would like to create jobs that will get scheduled
by
> SQL Server Agent.
> Thanks.
>
Showing posts with label intend. Show all posts
Showing posts with label intend. Show all posts
Monday, March 12, 2012
MSDE & SQL Server Agent
Can anyone tell me if the SQL Server Agent is included with MSDE? I realize
that Query Analyzer and Enterprise Manager are not included. I intend to use
MSDE for a project and would like to create jobs that will get scheduled by
SQL Server Agent.
Thanks.Yes, Agent is included.
--
Andrew J. Kelly SQL MVP
"Amos Soma" <amos_j_soma@.y_a_hoo.com> wrote in message
news:jMqdnVEia9dLsULdRVn-vA@.buckeye-express.com...
> Can anyone tell me if the SQL Server Agent is included with MSDE? I
realize
> that Query Analyzer and Enterprise Manager are not included. I intend to
use
> MSDE for a project and would like to create jobs that will get scheduled
by
> SQL Server Agent.
> Thanks.
>
that Query Analyzer and Enterprise Manager are not included. I intend to use
MSDE for a project and would like to create jobs that will get scheduled by
SQL Server Agent.
Thanks.Yes, Agent is included.
--
Andrew J. Kelly SQL MVP
"Amos Soma" <amos_j_soma@.y_a_hoo.com> wrote in message
news:jMqdnVEia9dLsULdRVn-vA@.buckeye-express.com...
> Can anyone tell me if the SQL Server Agent is included with MSDE? I
realize
> that Query Analyzer and Enterprise Manager are not included. I intend to
use
> MSDE for a project and would like to create jobs that will get scheduled
by
> SQL Server Agent.
> Thanks.
>
MSDE & SQL Server Agent
Can anyone tell me if the SQL Server Agent is included with MSDE? I realize
that Query Analyzer and Enterprise Manager are not included. I intend to use
MSDE for a project and would like to create jobs that will get scheduled by
SQL Server Agent.
Thanks.Yes, Agent is included.
Andrew J. Kelly SQL MVP
"Amos Soma" <amos_j_soma@.y_a_hoo.com> wrote in message
news:jMqdnVEia9dLsULdRVn-vA@.buckeye-express.com...
> Can anyone tell me if the SQL Server Agent is included with MSDE? I
realize
> that Query Analyzer and Enterprise Manager are not included. I intend to
use
> MSDE for a project and would like to create jobs that will get scheduled
by
> SQL Server Agent.
> Thanks.
>
that Query Analyzer and Enterprise Manager are not included. I intend to use
MSDE for a project and would like to create jobs that will get scheduled by
SQL Server Agent.
Thanks.Yes, Agent is included.
Andrew J. Kelly SQL MVP
"Amos Soma" <amos_j_soma@.y_a_hoo.com> wrote in message
news:jMqdnVEia9dLsULdRVn-vA@.buckeye-express.com...
> Can anyone tell me if the SQL Server Agent is included with MSDE? I
realize
> that Query Analyzer and Enterprise Manager are not included. I intend to
use
> MSDE for a project and would like to create jobs that will get scheduled
by
> SQL Server Agent.
> Thanks.
>
MSDE & EM Tools
Hi,
I intend using MSDE 2000 in conjunction with a fully licensed version of SQL
Server 2000. MSDE will be installed on several clients.
My understanding is as follows :
I can use Enterprise Manager on any or all of those client instances of MSDE
because I have a fully licensed copy of SQL Server 2000 with which they will
be replicating.
MSDN:
You can only use SQL Server tools and services in conjunction with MSDE if
you acquired MSDE through SQL Server 2000 (Developer Edition, Standard
Edition, or Enterprise Edition), and if you are using MSDE in conjunction
with a properly licensed copy of SQL Server 2000.
Am I in the clear?
Can I use any of the GUI tools?
Thanks in advance,
DOM.hi Dom,
Dom wrote:
> Hi,
> I intend using MSDE 2000 in conjunction with a fully licensed version
> of SQL Server 2000. MSDE will be installed on several clients.
> My understanding is as follows :
> I can use Enterprise Manager on any or all of those client instances
> of MSDE because I have a fully licensed copy of SQL Server 2000 with
> which they will be replicating.
> MSDN:
> You can only use SQL Server tools and services in conjunction with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE
> in conjunction with a properly licensed copy of SQL Server 2000.
> Am I in the clear?
> Can I use any of the GUI tools?
> Thanks in advance,
> DOM
please have a look at Steve Dybing answer in http://tinyurl.com/d2qpa .. it
does not seem this is a legal solution...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply|||Thanks Andrea,
I followed the link you mentioned and on that page was directed to the
following site:
http://www.aspfaq.com/show.asp?id=2442
which states :
If you have an existing machine with SQL Server client tools installed, you
can manage the MSDE instance through these... as long as you have a valid an
d
legal Client Access License (CAL).
You can take the SQL Server install CD, run it on the client(s), and choose
"Install client tools only" during setup. This will install Query Analyzer,
Enterprise Manager, and other useful tools—but will not install the databa
se
engine.
This was my understanding.
With a fully licensed MSSQL 2000 you can legally use the client tools on
MSDE 2000 clients'
DOM|||hi Dom,
Dom wrote:
> Thanks Andrea,
> I followed the link you mentioned and on that page was directed to the
> following site:
> http://www.aspfaq.com/show.asp?id=2442
> which states :
> If you have an existing machine with SQL Server client tools
> installed, you can manage the MSDE instance through these... as long
> as you have a valid and legal Client Access License (CAL).
> You can take the SQL Server install CD, run it on the client(s), and
> choose "Install client tools only" during setup. This will install
> Query Analyzer, Enterprise Manager, and other useful tools-but will
> not install the database engine.
> This was my understanding.
> With a fully licensed MSSQL 2000 you can legally use the client tools
> on MSDE 2000 clients'
I had a private conversation with Steve some time ago about this matter...
he is not a "legal" guy too... but he has been told by legal representatives
that EM (QA and so on) is not legitimated to be used against production MSDE
instances... this is the reason he posted that way...
so, in my understanding, you never (or quite never, but I do really have no
idea when it could be legal) are legitimated to use SQL Server Client Tools
to manage MSDE...
my $0.02
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
I intend using MSDE 2000 in conjunction with a fully licensed version of SQL
Server 2000. MSDE will be installed on several clients.
My understanding is as follows :
I can use Enterprise Manager on any or all of those client instances of MSDE
because I have a fully licensed copy of SQL Server 2000 with which they will
be replicating.
MSDN:
You can only use SQL Server tools and services in conjunction with MSDE if
you acquired MSDE through SQL Server 2000 (Developer Edition, Standard
Edition, or Enterprise Edition), and if you are using MSDE in conjunction
with a properly licensed copy of SQL Server 2000.
Am I in the clear?
Can I use any of the GUI tools?
Thanks in advance,
DOM.hi Dom,
Dom wrote:
> Hi,
> I intend using MSDE 2000 in conjunction with a fully licensed version
> of SQL Server 2000. MSDE will be installed on several clients.
> My understanding is as follows :
> I can use Enterprise Manager on any or all of those client instances
> of MSDE because I have a fully licensed copy of SQL Server 2000 with
> which they will be replicating.
> MSDN:
> You can only use SQL Server tools and services in conjunction with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE
> in conjunction with a properly licensed copy of SQL Server 2000.
> Am I in the clear?
> Can I use any of the GUI tools?
> Thanks in advance,
> DOM
please have a look at Steve Dybing answer in http://tinyurl.com/d2qpa .. it
does not seem this is a legal solution...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply|||Thanks Andrea,
I followed the link you mentioned and on that page was directed to the
following site:
http://www.aspfaq.com/show.asp?id=2442
which states :
If you have an existing machine with SQL Server client tools installed, you
can manage the MSDE instance through these... as long as you have a valid an
d
legal Client Access License (CAL).
You can take the SQL Server install CD, run it on the client(s), and choose
"Install client tools only" during setup. This will install Query Analyzer,
Enterprise Manager, and other useful tools—but will not install the databa
se
engine.
This was my understanding.
With a fully licensed MSSQL 2000 you can legally use the client tools on
MSDE 2000 clients'
DOM|||hi Dom,
Dom wrote:
> Thanks Andrea,
> I followed the link you mentioned and on that page was directed to the
> following site:
> http://www.aspfaq.com/show.asp?id=2442
> which states :
> If you have an existing machine with SQL Server client tools
> installed, you can manage the MSDE instance through these... as long
> as you have a valid and legal Client Access License (CAL).
> You can take the SQL Server install CD, run it on the client(s), and
> choose "Install client tools only" during setup. This will install
> Query Analyzer, Enterprise Manager, and other useful tools-but will
> not install the database engine.
> This was my understanding.
> With a fully licensed MSSQL 2000 you can legally use the client tools
> on MSDE 2000 clients'
I had a private conversation with Steve some time ago about this matter...
he is not a "legal" guy too... but he has been told by legal representatives
that EM (QA and so on) is not legitimated to be used against production MSDE
instances... this is the reason he posted that way...
so, in my understanding, you never (or quite never, but I do really have no
idea when it could be legal) are legitimated to use SQL Server Client Tools
to manage MSDE...
my $0.02
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
MSDE & EM Tools
Hi,
I intend using MSDE 2000 in conjunction with a fully licensed version of SQL
Server 2000. MSDE will be installed on several clients.
My understanding is as follows :
I can use Enterprise Manager on any or all of those client instances of MSDE
because I have a fully licensed copy of SQL Server 2000 with which they will
be replicating.
MSDN:
You can only use SQL Server tools and services in conjunction with MSDE if
you acquired MSDE through SQL Server 2000 (Developer Edition, Standard
Edition, or Enterprise Edition), and if you are using MSDE in conjunction
with a properly licensed copy of SQL Server 2000.
Am I in the clear?
Can I use any of the GUI tools?
Thanks in advance,
DOM.
hi Dom,
Dom wrote:
> Hi,
> I intend using MSDE 2000 in conjunction with a fully licensed version
> of SQL Server 2000. MSDE will be installed on several clients.
> My understanding is as follows :
> I can use Enterprise Manager on any or all of those client instances
> of MSDE because I have a fully licensed copy of SQL Server 2000 with
> which they will be replicating.
> MSDN:
> You can only use SQL Server tools and services in conjunction with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE
> in conjunction with a properly licensed copy of SQL Server 2000.
> Am I in the clear?
> Can I use any of the GUI tools?
> Thanks in advance,
> DOM
please have a look at Steve Dybing answer in http://tinyurl.com/d2qpa .. it
does not seem this is a legal solution...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea,
I followed the link you mentioned and on that page was directed to the
following site:
http://www.aspfaq.com/show.asp?id=2442
which states :
If you have an existing machine with SQL Server client tools installed, you
can manage the MSDE instance through these... as long as you have a valid and
legal Client Access License (CAL).
You can take the SQL Server install CD, run it on the client(s), and choose
"Install client tools only" during setup. This will install Query Analyzer,
Enterprise Manager, and other useful tools—but will not install the database
engine.
This was my understanding.
With a fully licensed MSSQL 2000 you can legally use the client tools on
MSDE 2000 clients?
DOM
|||hi Dom,
Dom wrote:
> Thanks Andrea,
> I followed the link you mentioned and on that page was directed to the
> following site:
> http://www.aspfaq.com/show.asp?id=2442
> which states :
> If you have an existing machine with SQL Server client tools
> installed, you can manage the MSDE instance through these... as long
> as you have a valid and legal Client Access License (CAL).
> You can take the SQL Server install CD, run it on the client(s), and
> choose "Install client tools only" during setup. This will install
> Query Analyzer, Enterprise Manager, and other useful tools-but will
> not install the database engine.
> This was my understanding.
> With a fully licensed MSSQL 2000 you can legally use the client tools
> on MSDE 2000 clients?
I had a private conversation with Steve some time ago about this matter...
he is not a "legal" guy too... but he has been told by legal representatives
that EM (QA and so on) is not legitimated to be used against production MSDE
instances... this is the reason he posted that way...
so, in my understanding, you never (or quite never, but I do really have no
idea when it could be legal) are legitimated to use SQL Server Client Tools
to manage MSDE...
my $0.02
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
I intend using MSDE 2000 in conjunction with a fully licensed version of SQL
Server 2000. MSDE will be installed on several clients.
My understanding is as follows :
I can use Enterprise Manager on any or all of those client instances of MSDE
because I have a fully licensed copy of SQL Server 2000 with which they will
be replicating.
MSDN:
You can only use SQL Server tools and services in conjunction with MSDE if
you acquired MSDE through SQL Server 2000 (Developer Edition, Standard
Edition, or Enterprise Edition), and if you are using MSDE in conjunction
with a properly licensed copy of SQL Server 2000.
Am I in the clear?
Can I use any of the GUI tools?
Thanks in advance,
DOM.
hi Dom,
Dom wrote:
> Hi,
> I intend using MSDE 2000 in conjunction with a fully licensed version
> of SQL Server 2000. MSDE will be installed on several clients.
> My understanding is as follows :
> I can use Enterprise Manager on any or all of those client instances
> of MSDE because I have a fully licensed copy of SQL Server 2000 with
> which they will be replicating.
> MSDN:
> You can only use SQL Server tools and services in conjunction with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE
> in conjunction with a properly licensed copy of SQL Server 2000.
> Am I in the clear?
> Can I use any of the GUI tools?
> Thanks in advance,
> DOM
please have a look at Steve Dybing answer in http://tinyurl.com/d2qpa .. it
does not seem this is a legal solution...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea,
I followed the link you mentioned and on that page was directed to the
following site:
http://www.aspfaq.com/show.asp?id=2442
which states :
If you have an existing machine with SQL Server client tools installed, you
can manage the MSDE instance through these... as long as you have a valid and
legal Client Access License (CAL).
You can take the SQL Server install CD, run it on the client(s), and choose
"Install client tools only" during setup. This will install Query Analyzer,
Enterprise Manager, and other useful tools—but will not install the database
engine.
This was my understanding.
With a fully licensed MSSQL 2000 you can legally use the client tools on
MSDE 2000 clients?
DOM
|||hi Dom,
Dom wrote:
> Thanks Andrea,
> I followed the link you mentioned and on that page was directed to the
> following site:
> http://www.aspfaq.com/show.asp?id=2442
> which states :
> If you have an existing machine with SQL Server client tools
> installed, you can manage the MSDE instance through these... as long
> as you have a valid and legal Client Access License (CAL).
> You can take the SQL Server install CD, run it on the client(s), and
> choose "Install client tools only" during setup. This will install
> Query Analyzer, Enterprise Manager, and other useful tools-but will
> not install the database engine.
> This was my understanding.
> With a fully licensed MSSQL 2000 you can legally use the client tools
> on MSDE 2000 clients?
I had a private conversation with Steve some time ago about this matter...
he is not a "legal" guy too... but he has been told by legal representatives
that EM (QA and so on) is not legitimated to be used against production MSDE
instances... this is the reason he posted that way...
so, in my understanding, you never (or quite never, but I do really have no
idea when it could be legal) are legitimated to use SQL Server Client Tools
to manage MSDE...
my $0.02
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
MSDE & EM Tools
Hi,
I intend using MSDE 2000 in conjunction with a fully licensed version of SQL
Server 2000. MSDE will be installed on several clients.
My understanding is as follows :
I can use Enterprise Manager on any or all of those client instances of MSDE
because I have a fully licensed copy of SQL Server 2000 with which they will
be replicating.
MSDN:
You can only use SQL Server tools and services in conjunction with MSDE if
you acquired MSDE through SQL Server 2000 (Developer Edition, Standard
Edition, or Enterprise Edition), and if you are using MSDE in conjunction
with a properly licensed copy of SQL Server 2000.
Am I in the clear?
Can I use any of the GUI tools?
Thanks in advance,
DOM.hi Dom,
Dom wrote:
> Hi,
> I intend using MSDE 2000 in conjunction with a fully licensed version
> of SQL Server 2000. MSDE will be installed on several clients.
> My understanding is as follows :
> I can use Enterprise Manager on any or all of those client instances
> of MSDE because I have a fully licensed copy of SQL Server 2000 with
> which they will be replicating.
> MSDN:
> You can only use SQL Server tools and services in conjunction with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE
> in conjunction with a properly licensed copy of SQL Server 2000.
> Am I in the clear?
> Can I use any of the GUI tools?
> Thanks in advance,
> DOM
please have a look at Steve Dybing answer in http://tinyurl.com/d2qpa .. it
does not seem this is a legal solution...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply|||Thanks Andrea,
I followed the link you mentioned and on that page was directed to the
following site:
http://www.aspfaq.com/show.asp?id=2442
which states :
If you have an existing machine with SQL Server client tools installed, you
can manage the MSDE instance through these... as long as you have a valid and
legal Client Access License (CAL).
You can take the SQL Server install CD, run it on the client(s), and choose
"Install client tools only" during setup. This will install Query Analyzer,
Enterprise Manager, and other useful toolsâ'but will not install the database
engine.
This was my understanding.
With a fully licensed MSSQL 2000 you can legally use the client tools on
MSDE 2000 clients'
DOM|||hi Dom,
Dom wrote:
> Thanks Andrea,
> I followed the link you mentioned and on that page was directed to the
> following site:
> http://www.aspfaq.com/show.asp?id=2442
> which states :
> If you have an existing machine with SQL Server client tools
> installed, you can manage the MSDE instance through these... as long
> as you have a valid and legal Client Access License (CAL).
> You can take the SQL Server install CD, run it on the client(s), and
> choose "Install client tools only" during setup. This will install
> Query Analyzer, Enterprise Manager, and other useful tools-but will
> not install the database engine.
> This was my understanding.
> With a fully licensed MSSQL 2000 you can legally use the client tools
> on MSDE 2000 clients'
I had a private conversation with Steve some time ago about this matter...
he is not a "legal" guy too... but he has been told by legal representatives
that EM (QA and so on) is not legitimated to be used against production MSDE
instances... this is the reason he posted that way...
so, in my understanding, you never (or quite never, but I do really have no
idea when it could be legal) are legitimated to use SQL Server Client Tools
to manage MSDE...
my $0.02
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
I intend using MSDE 2000 in conjunction with a fully licensed version of SQL
Server 2000. MSDE will be installed on several clients.
My understanding is as follows :
I can use Enterprise Manager on any or all of those client instances of MSDE
because I have a fully licensed copy of SQL Server 2000 with which they will
be replicating.
MSDN:
You can only use SQL Server tools and services in conjunction with MSDE if
you acquired MSDE through SQL Server 2000 (Developer Edition, Standard
Edition, or Enterprise Edition), and if you are using MSDE in conjunction
with a properly licensed copy of SQL Server 2000.
Am I in the clear?
Can I use any of the GUI tools?
Thanks in advance,
DOM.hi Dom,
Dom wrote:
> Hi,
> I intend using MSDE 2000 in conjunction with a fully licensed version
> of SQL Server 2000. MSDE will be installed on several clients.
> My understanding is as follows :
> I can use Enterprise Manager on any or all of those client instances
> of MSDE because I have a fully licensed copy of SQL Server 2000 with
> which they will be replicating.
> MSDN:
> You can only use SQL Server tools and services in conjunction with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE
> in conjunction with a properly licensed copy of SQL Server 2000.
> Am I in the clear?
> Can I use any of the GUI tools?
> Thanks in advance,
> DOM
please have a look at Steve Dybing answer in http://tinyurl.com/d2qpa .. it
does not seem this is a legal solution...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply|||Thanks Andrea,
I followed the link you mentioned and on that page was directed to the
following site:
http://www.aspfaq.com/show.asp?id=2442
which states :
If you have an existing machine with SQL Server client tools installed, you
can manage the MSDE instance through these... as long as you have a valid and
legal Client Access License (CAL).
You can take the SQL Server install CD, run it on the client(s), and choose
"Install client tools only" during setup. This will install Query Analyzer,
Enterprise Manager, and other useful toolsâ'but will not install the database
engine.
This was my understanding.
With a fully licensed MSSQL 2000 you can legally use the client tools on
MSDE 2000 clients'
DOM|||hi Dom,
Dom wrote:
> Thanks Andrea,
> I followed the link you mentioned and on that page was directed to the
> following site:
> http://www.aspfaq.com/show.asp?id=2442
> which states :
> If you have an existing machine with SQL Server client tools
> installed, you can manage the MSDE instance through these... as long
> as you have a valid and legal Client Access License (CAL).
> You can take the SQL Server install CD, run it on the client(s), and
> choose "Install client tools only" during setup. This will install
> Query Analyzer, Enterprise Manager, and other useful tools-but will
> not install the database engine.
> This was my understanding.
> With a fully licensed MSSQL 2000 you can legally use the client tools
> on MSDE 2000 clients'
I had a private conversation with Steve some time ago about this matter...
he is not a "legal" guy too... but he has been told by legal representatives
that EM (QA and so on) is not legitimated to be used against production MSDE
instances... this is the reason he posted that way...
so, in my understanding, you never (or quite never, but I do really have no
idea when it could be legal) are legitimated to use SQL Server Client Tools
to manage MSDE...
my $0.02
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Subscribe to:
Posts (Atom)