Discussion:
MSDE and SQL 2005 db?
(too old to reply)
senna4ever
2008-02-11 16:16:05 UTC
Permalink
Does anyone know if an existing SQL 2005 box can also host a MSDE db if the
comm ports are different ?

Thanks in advance!!
Andrea Montanari
2008-02-11 17:30:39 UTC
Permalink
hi,
Post by senna4ever
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 :) ).. 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
Loading...