HELP!!! -- SQL Server 2005 from 2000

6 Oct 2006 3:58 PM

segis bata

Hello everyone,

I'm writing you because I have this situation: I need to register a (remote)
SQL Server 2005 and currently we have SQL 2000. I can't do it using
Enterprise Manager.

Is there a way to do it *WITHOUT* upgrading to SQL 2005?!?

Please let me know if it's possible with SQL2000 and/or any other tool

Thanks in advance,
SB-R

6 Oct 2006 4:02 PM

Keith Kratochvil

Sure. Connect with Query Analyzer. It can do everything that Enterprise
Manager can -- you just need to use T-SQL to do it.

By the way, it seems that some of the newsgroups are not as relevant to this
question as others (olap, for example).

--
Keith Kratochvil

Show quote

"segis bata" <segisb***@hotmail.com> wrote in message
news:OXMXBAW6GHA.4500@TK2MSFTNGP02.phx.gbl...
> Hello everyone,
>
> I'm writing you because I have this situation: I need to register a
> (remote) SQL Server 2005 and currently we have SQL 2000. I can't do it
> using Enterprise Manager.
>
> Is there a way to do it *WITHOUT* upgrading to SQL 2005?!?
>
> Please let me know if it's possible with SQL2000 and/or any other tool
>
> Thanks in advance,
> SB-R
>

6 Oct 2006 5:22 PM

Martijn Tonies

Hi,

> I'm writing you because I have this situation: I need to register a
(remote)
> SQL Server 2005 and currently we have SQL 2000. I can't do it using
> Enterprise Manager.
>
> Is there a way to do it *WITHOUT* upgrading to SQL 2005?!?
>
> Please let me know if it's possible with SQL2000 and/or any other tool

Our database IDE "Database Workbench" supports connecting to both
SQL 2000 and SQL 2005 just fine. Download yourself a trial copy at
www.upscene.com

--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

7 Oct 2006 8:54 PM

lucm

segis bata wrote:

> Hello everyone,
>
> I'm writing you because I have this situation: I need to register a (remote)
> SQL Server 2005 and currently we have SQL 2000. I can't do it using
> Enterprise Manager.
>
> Is there a way to do it *WITHOUT* upgrading to SQL 2005?!?
>
> Please let me know if it's possible with SQL2000 and/or any other tool
>
> Thanks in advance,
> SB-R

You could try the SQL Server Management Studio Express, which is free.
It is designed for SQL 2005 express but should allow you to connect to
SQL 2000 as well. However I am not sure if you will have access to
extended features, like DTS.

Or you could purchase a SQL Server 2005 Developer Edition license for
50$ and enjoy the complete features of Management Studio.

Regards,
lucm