hi,
Post by senna4everDoes 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 :) ).. 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