Saturday, February 25, 2012

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

No comments:

Post a Comment