Enterprise Manager?

If I understand correctly, Enterprise manager has been replaced with SQL Ser
ver 2005
Express?
Can I use SQL Server 2005 Express from my desktop to connect to an SQL 2000
database on
the internet?
Thanks,
VicAm Fri, 21 Jul 2006 23:14:27 -0400 schrieb Victor:

> If I understand correctly, Enterprise manager has been replaced with SQL S
erver 2005
> Express?
> Can I use SQL Server 2005 Express from my desktop to connect to an SQL 200
0 database on
> the internet?
> Thanks,
> Vic
You can use the new Server Management Studio Express to manage SQL2005 and
SQL2000, no problem. You can even use the old QueryAnalizer from SQL2000 to
work with SQL2005. Only EM is not compatible.
And if you connect over internet, then the only problems may be when
routers or firewalls are not right configured. I support all my clients, no
matter if MSDE, SQLExpress or any other server edition, over internet.
bye, Helmut|||"Helmut Woess" wrote...
> Am Fri, 21 Jul 2006 23:14:27 -0400 schrieb Victor:
>
on[vbcol=seagreen]
> You can use the new Server Management Studio Express to manage SQL2005 and
> SQL2000, no problem. You can even use the old QueryAnalizer from SQL2000 t
o
> work with SQL2005. Only EM is not compatible.
> And if you connect over internet, then the only problems may be when
> routers or firewalls are not right configured. I support all my clients, n
o
> matter if MSDE, SQLExpress or any other server edition, over internet.
> bye, Helmut
Thanks, Helmut!
From here:
http://msdn.microsoft.com/vstudio/express/sql/download/
I downloaded "SQL Server 2005 Express Edition with Advanced Services SP1" be
cause it
supports full-text search (which my SQL 2000 db uses). Is that all I need?
How does my firewall need to be configured? I assume that if I access my db
over the
Internet, Server Management Studio Express will require a particular port to
access my
db over the Internet.
Also, can Server Management Studio Express be used to access a remote mysql
database?
Thanks so much!!!
Vic