Hi all, I just finished installing SQL 2005 Enterprise on my server. Now
what tools can I install on my client Windows XP PC to manage and control
the server? With 2000, I could install Enterprise Manager & Query Analyzer
on my Windows XP machine. I dont see any such option now? My client PC
already has VS2005 installed. Can I use that? Essentially I am looking for
something that can give me all the functionality of Enterprise Manager +
Query Analyzer.
TIA!On Tue, 8 Nov 2005 09:16:51 -0600, <param@.community.nospam> wrote:
>Hi all, I just finished installing SQL 2005 Enterprise on my server. Now
>what tools can I install on my client Windows XP PC to manage and control
>the server? With 2000, I could install Enterprise Manager & Query Analyzer
>on my Windows XP machine. I dont see any such option now? My client PC
>already has VS2005 installed. Can I use that? Essentially I am looking for
>something that can give me all the functionality of Enterprise Manager +
>Query Analyzer.
>TIA!
>
You are looking for "SQLServer management studio". And it has the
functionality of Enterprise manager + query analyzer combined, like you
ordered! I liked a lighter program like isqlw.
Joachim.
--
This post is free post; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
Joachim Verhagen
http://www.xs4all.nl/~jcdverha/ (Science Jokes)|||Do I download that from somewhere? How do I install it? Also, can I install
it on a machine with VS2005?
Thanks a Bunch!
"Joachim Verhagen" <joachim.verhagen@.xs4all.nl> wrote in message
news:0ou1n1d8866oa3ndpkl1o6v1pgejko3re3@.
4ax.com...
> On Tue, 8 Nov 2005 09:16:51 -0600, <param@.community.nospam> wrote:
>
>
> You are looking for "SQLServer management studio". And it has the
> functionality of Enterprise manager + query analyzer combined, like you
> ordered! I liked a lighter program like isqlw.
>
> Joachim.
> --
> This post is free post; you can redistribute it and/or
> modify it under the terms of the GNU General Public License
> as published by the Free Software Foundation; either version 2
> of the License, or (at your option) any later version.
> Joachim Verhagen
> http://www.xs4all.nl/~jcdverha/ (Science Jokes)|||You can install the SQL 2005 workstation components from your SQL Server
installation media. No problem installing along side of the VS 2005 RTM.
It is important that any VS and SQL Server beta/CTP builds be removed before
installing the RTM bits.
Hope this helps.
Dan Guzman
SQL Server MVP
<param@.community.nospam> wrote in message
news:eUtdAXK5FHA.3496@.TK2MSFTNGP10.phx.gbl...
> Do I download that from somewhere? How do I install it? Also, can I
> install it on a machine with VS2005?
> Thanks a Bunch!
> "Joachim Verhagen" <joachim.verhagen@.xs4all.nl> wrote in message
> news:0ou1n1d8866oa3ndpkl1o6v1pgejko3re3@.
4ax.com...
>|||Yes I removed all Betas & installed RTM on both machines. I never tried
doing a workstation components install only. I will try it and see how it
goes.
TIA!
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:enq6lCN5FHA.3880@.TK2MSFTNGP12.phx.gbl...
> You can install the SQL 2005 workstation components from your SQL Server
> installation media. No problem installing along side of the VS 2005 RTM.
> It is important that any VS and SQL Server beta/CTP builds be removed
> before installing the RTM bits.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> <param@.community.nospam> wrote in message
> news:eUtdAXK5FHA.3496@.TK2MSFTNGP10.phx.gbl...
>
Showing posts with label manage. Show all posts
Showing posts with label manage. Show all posts
Saturday, February 25, 2012
2005 tools
Hi all, I just finished installing SQL 2005 Enterprise on my server. Now
what tools can I install on my client Windows XP PC to manage and control
the server? With 2000, I could install Enterprise Manager & Query Analyzer
on my Windows XP machine. I dont see any such option now? My client PC
already has VS2005 installed. Can I use that? Essentially I am looking for
something that can give me all the functionality of Enterprise Manager +
Query Analyzer.
TIA!On Tue, 8 Nov 2005 09:16:51 -0600, <param@.community.nospam> wrote:
>Hi all, I just finished installing SQL 2005 Enterprise on my server. Now
>what tools can I install on my client Windows XP PC to manage and control
>the server? With 2000, I could install Enterprise Manager & Query Analyzer
>on my Windows XP machine. I dont see any such option now? My client PC
>already has VS2005 installed. Can I use that? Essentially I am looking for
>something that can give me all the functionality of Enterprise Manager +
>Query Analyzer.
>TIA!
>
You are looking for "SQLServer management studio". And it has the
functionality of Enterprise manager + query analyzer combined, like you
ordered! I liked a lighter program like isqlw.
Joachim.
--
This post is free post; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
Joachim Verhagen
http://www.xs4all.nl/~jcdverha/ (Science Jokes)|||Do I download that from somewhere? How do I install it? Also, can I install
it on a machine with VS2005?
Thanks a Bunch!
"Joachim Verhagen" <joachim.verhagen@.xs4all.nl> wrote in message
news:0ou1n1d8866oa3ndpkl1o6v1pgejko3re3@.4ax.com...
> On Tue, 8 Nov 2005 09:16:51 -0600, <param@.community.nospam> wrote:
>>Hi all, I just finished installing SQL 2005 Enterprise on my server. Now
>>what tools can I install on my client Windows XP PC to manage and control
>>the server? With 2000, I could install Enterprise Manager & Query Analyzer
>>on my Windows XP machine. I dont see any such option now? My client PC
>>already has VS2005 installed. Can I use that? Essentially I am looking for
>>something that can give me all the functionality of Enterprise Manager +
>>Query Analyzer.
>>TIA!
>
> You are looking for "SQLServer management studio". And it has the
> functionality of Enterprise manager + query analyzer combined, like you
> ordered! I liked a lighter program like isqlw.
>
> Joachim.
> --
> This post is free post; you can redistribute it and/or
> modify it under the terms of the GNU General Public License
> as published by the Free Software Foundation; either version 2
> of the License, or (at your option) any later version.
> Joachim Verhagen
> http://www.xs4all.nl/~jcdverha/ (Science Jokes)|||You can install the SQL 2005 workstation components from your SQL Server
installation media. No problem installing along side of the VS 2005 RTM.
It is important that any VS and SQL Server beta/CTP builds be removed before
installing the RTM bits.
--
Hope this helps.
Dan Guzman
SQL Server MVP
<param@.community.nospam> wrote in message
news:eUtdAXK5FHA.3496@.TK2MSFTNGP10.phx.gbl...
> Do I download that from somewhere? How do I install it? Also, can I
> install it on a machine with VS2005?
> Thanks a Bunch!
> "Joachim Verhagen" <joachim.verhagen@.xs4all.nl> wrote in message
> news:0ou1n1d8866oa3ndpkl1o6v1pgejko3re3@.4ax.com...
>> On Tue, 8 Nov 2005 09:16:51 -0600, <param@.community.nospam> wrote:
>>Hi all, I just finished installing SQL 2005 Enterprise on my server. Now
>>what tools can I install on my client Windows XP PC to manage and control
>>the server? With 2000, I could install Enterprise Manager & Query
>>Analyzer
>>on my Windows XP machine. I dont see any such option now? My client PC
>>already has VS2005 installed. Can I use that? Essentially I am looking
>>for
>>something that can give me all the functionality of Enterprise Manager +
>>Query Analyzer.
>>TIA!
>>
>> You are looking for "SQLServer management studio". And it has the
>> functionality of Enterprise manager + query analyzer combined, like you
>> ordered! I liked a lighter program like isqlw.
>>
>> Joachim.
>> --
>> This post is free post; you can redistribute it and/or
>> modify it under the terms of the GNU General Public License
>> as published by the Free Software Foundation; either version 2
>> of the License, or (at your option) any later version.
>> Joachim Verhagen
>> http://www.xs4all.nl/~jcdverha/ (Science Jokes)
>|||Yes I removed all Betas & installed RTM on both machines. I never tried
doing a workstation components install only. I will try it and see how it
goes.
TIA!
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:enq6lCN5FHA.3880@.TK2MSFTNGP12.phx.gbl...
> You can install the SQL 2005 workstation components from your SQL Server
> installation media. No problem installing along side of the VS 2005 RTM.
> It is important that any VS and SQL Server beta/CTP builds be removed
> before installing the RTM bits.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> <param@.community.nospam> wrote in message
> news:eUtdAXK5FHA.3496@.TK2MSFTNGP10.phx.gbl...
>> Do I download that from somewhere? How do I install it? Also, can I
>> install it on a machine with VS2005?
>> Thanks a Bunch!
>> "Joachim Verhagen" <joachim.verhagen@.xs4all.nl> wrote in message
>> news:0ou1n1d8866oa3ndpkl1o6v1pgejko3re3@.4ax.com...
>> On Tue, 8 Nov 2005 09:16:51 -0600, <param@.community.nospam> wrote:
>>Hi all, I just finished installing SQL 2005 Enterprise on my server. Now
>>what tools can I install on my client Windows XP PC to manage and
>>control
>>the server? With 2000, I could install Enterprise Manager & Query
>>Analyzer
>>on my Windows XP machine. I dont see any such option now? My client PC
>>already has VS2005 installed. Can I use that? Essentially I am looking
>>for
>>something that can give me all the functionality of Enterprise Manager +
>>Query Analyzer.
>>TIA!
>>
>> You are looking for "SQLServer management studio". And it has the
>> functionality of Enterprise manager + query analyzer combined, like you
>> ordered! I liked a lighter program like isqlw.
>>
>> Joachim.
>> --
>> This post is free post; you can redistribute it and/or
>> modify it under the terms of the GNU General Public License
>> as published by the Free Software Foundation; either version 2
>> of the License, or (at your option) any later version.
>> Joachim Verhagen
>> http://www.xs4all.nl/~jcdverha/ (Science Jokes)
>>
>
what tools can I install on my client Windows XP PC to manage and control
the server? With 2000, I could install Enterprise Manager & Query Analyzer
on my Windows XP machine. I dont see any such option now? My client PC
already has VS2005 installed. Can I use that? Essentially I am looking for
something that can give me all the functionality of Enterprise Manager +
Query Analyzer.
TIA!On Tue, 8 Nov 2005 09:16:51 -0600, <param@.community.nospam> wrote:
>Hi all, I just finished installing SQL 2005 Enterprise on my server. Now
>what tools can I install on my client Windows XP PC to manage and control
>the server? With 2000, I could install Enterprise Manager & Query Analyzer
>on my Windows XP machine. I dont see any such option now? My client PC
>already has VS2005 installed. Can I use that? Essentially I am looking for
>something that can give me all the functionality of Enterprise Manager +
>Query Analyzer.
>TIA!
>
You are looking for "SQLServer management studio". And it has the
functionality of Enterprise manager + query analyzer combined, like you
ordered! I liked a lighter program like isqlw.
Joachim.
--
This post is free post; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
Joachim Verhagen
http://www.xs4all.nl/~jcdverha/ (Science Jokes)|||Do I download that from somewhere? How do I install it? Also, can I install
it on a machine with VS2005?
Thanks a Bunch!
"Joachim Verhagen" <joachim.verhagen@.xs4all.nl> wrote in message
news:0ou1n1d8866oa3ndpkl1o6v1pgejko3re3@.4ax.com...
> On Tue, 8 Nov 2005 09:16:51 -0600, <param@.community.nospam> wrote:
>>Hi all, I just finished installing SQL 2005 Enterprise on my server. Now
>>what tools can I install on my client Windows XP PC to manage and control
>>the server? With 2000, I could install Enterprise Manager & Query Analyzer
>>on my Windows XP machine. I dont see any such option now? My client PC
>>already has VS2005 installed. Can I use that? Essentially I am looking for
>>something that can give me all the functionality of Enterprise Manager +
>>Query Analyzer.
>>TIA!
>
> You are looking for "SQLServer management studio". And it has the
> functionality of Enterprise manager + query analyzer combined, like you
> ordered! I liked a lighter program like isqlw.
>
> Joachim.
> --
> This post is free post; you can redistribute it and/or
> modify it under the terms of the GNU General Public License
> as published by the Free Software Foundation; either version 2
> of the License, or (at your option) any later version.
> Joachim Verhagen
> http://www.xs4all.nl/~jcdverha/ (Science Jokes)|||You can install the SQL 2005 workstation components from your SQL Server
installation media. No problem installing along side of the VS 2005 RTM.
It is important that any VS and SQL Server beta/CTP builds be removed before
installing the RTM bits.
--
Hope this helps.
Dan Guzman
SQL Server MVP
<param@.community.nospam> wrote in message
news:eUtdAXK5FHA.3496@.TK2MSFTNGP10.phx.gbl...
> Do I download that from somewhere? How do I install it? Also, can I
> install it on a machine with VS2005?
> Thanks a Bunch!
> "Joachim Verhagen" <joachim.verhagen@.xs4all.nl> wrote in message
> news:0ou1n1d8866oa3ndpkl1o6v1pgejko3re3@.4ax.com...
>> On Tue, 8 Nov 2005 09:16:51 -0600, <param@.community.nospam> wrote:
>>Hi all, I just finished installing SQL 2005 Enterprise on my server. Now
>>what tools can I install on my client Windows XP PC to manage and control
>>the server? With 2000, I could install Enterprise Manager & Query
>>Analyzer
>>on my Windows XP machine. I dont see any such option now? My client PC
>>already has VS2005 installed. Can I use that? Essentially I am looking
>>for
>>something that can give me all the functionality of Enterprise Manager +
>>Query Analyzer.
>>TIA!
>>
>> You are looking for "SQLServer management studio". And it has the
>> functionality of Enterprise manager + query analyzer combined, like you
>> ordered! I liked a lighter program like isqlw.
>>
>> Joachim.
>> --
>> This post is free post; you can redistribute it and/or
>> modify it under the terms of the GNU General Public License
>> as published by the Free Software Foundation; either version 2
>> of the License, or (at your option) any later version.
>> Joachim Verhagen
>> http://www.xs4all.nl/~jcdverha/ (Science Jokes)
>|||Yes I removed all Betas & installed RTM on both machines. I never tried
doing a workstation components install only. I will try it and see how it
goes.
TIA!
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:enq6lCN5FHA.3880@.TK2MSFTNGP12.phx.gbl...
> You can install the SQL 2005 workstation components from your SQL Server
> installation media. No problem installing along side of the VS 2005 RTM.
> It is important that any VS and SQL Server beta/CTP builds be removed
> before installing the RTM bits.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> <param@.community.nospam> wrote in message
> news:eUtdAXK5FHA.3496@.TK2MSFTNGP10.phx.gbl...
>> Do I download that from somewhere? How do I install it? Also, can I
>> install it on a machine with VS2005?
>> Thanks a Bunch!
>> "Joachim Verhagen" <joachim.verhagen@.xs4all.nl> wrote in message
>> news:0ou1n1d8866oa3ndpkl1o6v1pgejko3re3@.4ax.com...
>> On Tue, 8 Nov 2005 09:16:51 -0600, <param@.community.nospam> wrote:
>>Hi all, I just finished installing SQL 2005 Enterprise on my server. Now
>>what tools can I install on my client Windows XP PC to manage and
>>control
>>the server? With 2000, I could install Enterprise Manager & Query
>>Analyzer
>>on my Windows XP machine. I dont see any such option now? My client PC
>>already has VS2005 installed. Can I use that? Essentially I am looking
>>for
>>something that can give me all the functionality of Enterprise Manager +
>>Query Analyzer.
>>TIA!
>>
>> You are looking for "SQLServer management studio". And it has the
>> functionality of Enterprise manager + query analyzer combined, like you
>> ordered! I liked a lighter program like isqlw.
>>
>> Joachim.
>> --
>> This post is free post; you can redistribute it and/or
>> modify it under the terms of the GNU General Public License
>> as published by the Free Software Foundation; either version 2
>> of the License, or (at your option) any later version.
>> Joachim Verhagen
>> http://www.xs4all.nl/~jcdverha/ (Science Jokes)
>>
>
2005 tools
I have a copy of sql 2005 and am wondering if I can load the client tools to
manage my sql server 2000 machines? If so, are there any thing I need to
watch out for? I don't want to break my test or production servers.
--
Thanks
PaulThis is a multi-part message in MIME format.
--000809050308000708010407
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Paul Bergson wrote:
> I have a copy of sql 2005 and am wondering if I can load the client tools to
> manage my sql server 2000 machines? If so, are there any thing I need to
> watch out for? I don't want to break my test or production servers.
>
>
There are no problems in managing a SQL2000 instance with SQL Server
Management Studio. If you use DTS packages though, you can't edit them
in SQL Server Management Studio but I think that's one of the only
limitations I can think of.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator
--000809050308000708010407
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Paul Bergson wrote:
<blockquote cite="mid%23wV19I$rGHA.4272@.TK2MSFTNGP03.phx.gbl"
type="cite">
<pre wrap="">I have a copy of sql 2005 and am wondering if I can load the client tools to
manage my sql server 2000 machines? If so, are there any thing I need to
watch out for? I don't want to break my test or production servers.
</pre>
</blockquote>
<font size="-1"><font face="Arial">There are no problems in managing a
SQL2000 instance with SQL Server Management Studio. If you use DTS
packages though, you can't edit them in SQL Server Management Studio
but I think that's one of the only limitations I can think of.<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
</font></font>
</body>
</html>
--000809050308000708010407--|||Alright I will load it up. If I recall correctly, there are a whole bunch
of install options. Are you aware of a web page that provides details on
what to select and not select?
Paul Bergson MCT, MCSE, MCSA, Security+, CNE, CNA, CCA
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:%23WrwmS$rGHA.5072@.TK2MSFTNGP05.phx.gbl...
> Paul Bergson wrote:
>> I have a copy of sql 2005 and am wondering if I can load the client tools
>> to
>> manage my sql server 2000 machines? If so, are there any thing I need to
>> watch out for? I don't want to break my test or production servers.
>>
> There are no problems in managing a SQL2000 instance with SQL Server
> Management Studio. If you use DTS packages though, you can't edit them
> in SQL Server Management Studio but I think that's one of the only
> limitations I can think of.
>
> --
> Regards
> Steen Schlüter Persson
> Databaseadministrator / Systemadministrator
>|||Paul Bergson wrote:
> I have a copy of sql 2005 and am wondering if I can load the client tools to
> manage my sql server 2000 machines? If so, are there any thing I need to
> watch out for? I don't want to break my test or production servers.
>
You can manage your 2000 servers using Management Studio, and you CAN
edit legacy DTS packages if you download the optional DTS designer for
Management Studio:
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
Tracy McKibben
MCDBA
http://www.realsqlguy.com
manage my sql server 2000 machines? If so, are there any thing I need to
watch out for? I don't want to break my test or production servers.
--
Thanks
PaulThis is a multi-part message in MIME format.
--000809050308000708010407
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Paul Bergson wrote:
> I have a copy of sql 2005 and am wondering if I can load the client tools to
> manage my sql server 2000 machines? If so, are there any thing I need to
> watch out for? I don't want to break my test or production servers.
>
>
There are no problems in managing a SQL2000 instance with SQL Server
Management Studio. If you use DTS packages though, you can't edit them
in SQL Server Management Studio but I think that's one of the only
limitations I can think of.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator
--000809050308000708010407
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Paul Bergson wrote:
<blockquote cite="mid%23wV19I$rGHA.4272@.TK2MSFTNGP03.phx.gbl"
type="cite">
<pre wrap="">I have a copy of sql 2005 and am wondering if I can load the client tools to
manage my sql server 2000 machines? If so, are there any thing I need to
watch out for? I don't want to break my test or production servers.
</pre>
</blockquote>
<font size="-1"><font face="Arial">There are no problems in managing a
SQL2000 instance with SQL Server Management Studio. If you use DTS
packages though, you can't edit them in SQL Server Management Studio
but I think that's one of the only limitations I can think of.<br>
<br>
<br>
-- <br>
Regards<br>
Steen Schlüter Persson<br>
Databaseadministrator / Systemadministrator<br>
</font></font>
</body>
</html>
--000809050308000708010407--|||Alright I will load it up. If I recall correctly, there are a whole bunch
of install options. Are you aware of a web page that provides details on
what to select and not select?
Paul Bergson MCT, MCSE, MCSA, Security+, CNE, CNA, CCA
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:%23WrwmS$rGHA.5072@.TK2MSFTNGP05.phx.gbl...
> Paul Bergson wrote:
>> I have a copy of sql 2005 and am wondering if I can load the client tools
>> to
>> manage my sql server 2000 machines? If so, are there any thing I need to
>> watch out for? I don't want to break my test or production servers.
>>
> There are no problems in managing a SQL2000 instance with SQL Server
> Management Studio. If you use DTS packages though, you can't edit them
> in SQL Server Management Studio but I think that's one of the only
> limitations I can think of.
>
> --
> Regards
> Steen Schlüter Persson
> Databaseadministrator / Systemadministrator
>|||Paul Bergson wrote:
> I have a copy of sql 2005 and am wondering if I can load the client tools to
> manage my sql server 2000 machines? If so, are there any thing I need to
> watch out for? I don't want to break my test or production servers.
>
You can manage your 2000 servers using Management Studio, and you CAN
edit legacy DTS packages if you download the optional DTS designer for
Management Studio:
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
Tracy McKibben
MCDBA
http://www.realsqlguy.com
2005 tools
Hi all, I just finished installing SQL 2005 Enterprise on my server. Now
what tools can I install on my client Windows XP PC to manage and control
the server? With 2000, I could install Enterprise Manager & Query Analyzer
on my Windows XP machine. I dont see any such option now? My client PC
already has VS2005 installed. Can I use that? Essentially I am looking for
something that can give me all the functionality of Enterprise Manager +
Query Analyzer.
TIA!
On Tue, 8 Nov 2005 09:16:51 -0600, <param@.community.nospam> wrote:
>Hi all, I just finished installing SQL 2005 Enterprise on my server. Now
>what tools can I install on my client Windows XP PC to manage and control
>the server? With 2000, I could install Enterprise Manager & Query Analyzer
>on my Windows XP machine. I dont see any such option now? My client PC
>already has VS2005 installed. Can I use that? Essentially I am looking for
>something that can give me all the functionality of Enterprise Manager +
>Query Analyzer.
>TIA!
>
You are looking for "SQLServer management studio". And it has the
functionality of Enterprise manager + query analyzer combined, like you
ordered! I liked a lighter program like isqlw.
Joachim.
This post is free post; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
Joachim Verhagen
http://www.xs4all.nl/~jcdverha/ (Science Jokes)
|||Do I download that from somewhere? How do I install it? Also, can I install
it on a machine with VS2005?
Thanks a Bunch!
"Joachim Verhagen" <joachim.verhagen@.xs4all.nl> wrote in message
news:0ou1n1d8866oa3ndpkl1o6v1pgejko3re3@.4ax.com...
> On Tue, 8 Nov 2005 09:16:51 -0600, <param@.community.nospam> wrote:
>
> You are looking for "SQLServer management studio". And it has the
> functionality of Enterprise manager + query analyzer combined, like you
> ordered! I liked a lighter program like isqlw.
>
> Joachim.
> --
> This post is free post; you can redistribute it and/or
> modify it under the terms of the GNU General Public License
> as published by the Free Software Foundation; either version 2
> of the License, or (at your option) any later version.
> Joachim Verhagen
> http://www.xs4all.nl/~jcdverha/ (Science Jokes)
|||You can install the SQL 2005 workstation components from your SQL Server
installation media. No problem installing along side of the VS 2005 RTM.
It is important that any VS and SQL Server beta/CTP builds be removed before
installing the RTM bits.
Hope this helps.
Dan Guzman
SQL Server MVP
<param@.community.nospam> wrote in message
news:eUtdAXK5FHA.3496@.TK2MSFTNGP10.phx.gbl...
> Do I download that from somewhere? How do I install it? Also, can I
> install it on a machine with VS2005?
> Thanks a Bunch!
> "Joachim Verhagen" <joachim.verhagen@.xs4all.nl> wrote in message
> news:0ou1n1d8866oa3ndpkl1o6v1pgejko3re3@.4ax.com...
>
|||Yes I removed all Betas & installed RTM on both machines. I never tried
doing a workstation components install only. I will try it and see how it
goes.
TIA!
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:enq6lCN5FHA.3880@.TK2MSFTNGP12.phx.gbl...
> You can install the SQL 2005 workstation components from your SQL Server
> installation media. No problem installing along side of the VS 2005 RTM.
> It is important that any VS and SQL Server beta/CTP builds be removed
> before installing the RTM bits.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> <param@.community.nospam> wrote in message
> news:eUtdAXK5FHA.3496@.TK2MSFTNGP10.phx.gbl...
>
what tools can I install on my client Windows XP PC to manage and control
the server? With 2000, I could install Enterprise Manager & Query Analyzer
on my Windows XP machine. I dont see any such option now? My client PC
already has VS2005 installed. Can I use that? Essentially I am looking for
something that can give me all the functionality of Enterprise Manager +
Query Analyzer.
TIA!
On Tue, 8 Nov 2005 09:16:51 -0600, <param@.community.nospam> wrote:
>Hi all, I just finished installing SQL 2005 Enterprise on my server. Now
>what tools can I install on my client Windows XP PC to manage and control
>the server? With 2000, I could install Enterprise Manager & Query Analyzer
>on my Windows XP machine. I dont see any such option now? My client PC
>already has VS2005 installed. Can I use that? Essentially I am looking for
>something that can give me all the functionality of Enterprise Manager +
>Query Analyzer.
>TIA!
>
You are looking for "SQLServer management studio". And it has the
functionality of Enterprise manager + query analyzer combined, like you
ordered! I liked a lighter program like isqlw.
Joachim.
This post is free post; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
Joachim Verhagen
http://www.xs4all.nl/~jcdverha/ (Science Jokes)
|||Do I download that from somewhere? How do I install it? Also, can I install
it on a machine with VS2005?
Thanks a Bunch!
"Joachim Verhagen" <joachim.verhagen@.xs4all.nl> wrote in message
news:0ou1n1d8866oa3ndpkl1o6v1pgejko3re3@.4ax.com...
> On Tue, 8 Nov 2005 09:16:51 -0600, <param@.community.nospam> wrote:
>
> You are looking for "SQLServer management studio". And it has the
> functionality of Enterprise manager + query analyzer combined, like you
> ordered! I liked a lighter program like isqlw.
>
> Joachim.
> --
> This post is free post; you can redistribute it and/or
> modify it under the terms of the GNU General Public License
> as published by the Free Software Foundation; either version 2
> of the License, or (at your option) any later version.
> Joachim Verhagen
> http://www.xs4all.nl/~jcdverha/ (Science Jokes)
|||You can install the SQL 2005 workstation components from your SQL Server
installation media. No problem installing along side of the VS 2005 RTM.
It is important that any VS and SQL Server beta/CTP builds be removed before
installing the RTM bits.
Hope this helps.
Dan Guzman
SQL Server MVP
<param@.community.nospam> wrote in message
news:eUtdAXK5FHA.3496@.TK2MSFTNGP10.phx.gbl...
> Do I download that from somewhere? How do I install it? Also, can I
> install it on a machine with VS2005?
> Thanks a Bunch!
> "Joachim Verhagen" <joachim.verhagen@.xs4all.nl> wrote in message
> news:0ou1n1d8866oa3ndpkl1o6v1pgejko3re3@.4ax.com...
>
|||Yes I removed all Betas & installed RTM on both machines. I never tried
doing a workstation components install only. I will try it and see how it
goes.
TIA!
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:enq6lCN5FHA.3880@.TK2MSFTNGP12.phx.gbl...
> You can install the SQL 2005 workstation components from your SQL Server
> installation media. No problem installing along side of the VS 2005 RTM.
> It is important that any VS and SQL Server beta/CTP builds be removed
> before installing the RTM bits.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> <param@.community.nospam> wrote in message
> news:eUtdAXK5FHA.3496@.TK2MSFTNGP10.phx.gbl...
>
Monday, February 13, 2012
2005 Express - SPs read-only
I am attempting to use a select SP with params to return data to MS Access. I am using SQL Server Management Express to manage SQL Server 2005. I can create tables, views and SPs just fine. Tables and views return data that is r/w but ALL SELECT SPs return data that is Read Only. Is this normal? I am under the impression that SPs can be used to return data to Access forms which is updateable, but I cannot even edit the data for an SP directly out in SMSE, never mind in Access.
TIA for any assistance on this,
John W. ColbyIf I understand your question properly, you are using a stored procedure to return a data set to a Microsoft Access form. If that is the case, then the result set is not updateable. In other words, you can't run a stored procedure, get some data, and then update that data on the screen and expect it to change in the database. You would need to code another stored procedure to take the updates and perform an UPDATE or INSERT statement back to the database from your Access form.
2005 Express - SPs read-only
I am attempting to use a select SP with params to return data to MS Access. I am using SQL Server Management Express to manage SQL Server 2005. I can create tables, views and SPs just fine. Tables and views return data that is r/w but ALL SELECT SPs return data that is Read Only. Is this normal? I am under the impression that SPs can be used to return data to Access forms which is updateable, but I cannot even edit the data for an SP directly out in SMSE, never mind in Access.
TIA for any assistance on this,
John W. ColbyIf I understand your question properly, you are using a stored procedure to return a data set to a Microsoft Access form. If that is the case, then the result set is not updateable. In other words, you can't run a stored procedure, get some data, and then update that data on the screen and expect it to change in the database. You would need to code another stored procedure to take the updates and perform an UPDATE or INSERT statement back to the database from your Access form.
Subscribe to:
Posts (Atom)