MSDE and SQL 2005 db?

External Since: Feb 11, 2008 Posts: 1

Does anyone know if an existing SQL 2005 box can also host a MSDE db if the
comm ports are different ?

Thanks in advance!!

External Since: Sep 13, 2003 Posts: 851

hi,
senna4ever wrote:
> Does anyone know if an existing SQL 2005 box can also host a MSDE db
> if the comm ports are different ?
>
SQL Server 2005 can manage an MSDE database (and COMM ports are not involved
at all in the game Smile

).. as soon as you attach an MSDE database to a SQL
Server 2005 instance the database will be upgraded in the metadata and can
no be longer ne managed by MSDE any more.. it's a one way ticket..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply