|
|
Posted by Erland Sommarskog on 08/08/06 21:57
farseer (farseer@optonline.net) writes:
> -If i installed Express Edition, Can both SQL Server 2005 and Express
> Edition coincide peacefully on the same PC?
Yes. SQL Server permits multiple instances being installed on the same
server, and this can be multiple instance of Express Edition, multiple
instance of, say, Enterprise Edition, or any mix thereof.
Furthermore, to prevent collisions, SQL Express installs by default as
a named instance, \SQLEXPRESS whereas other editions of SQL Server by
default installs as default instances, which do not have any extra
name,
> -Which one will Visual Studio see?
The one you point it to. I assume here that you mean the database that
you connect to for development purposes.
Some parts of VS like the compoent in Team System for Database
development uses the Express instance for its own storage.
> -When VS2005 is installed, which SQL Server is installed and how can i
> tell which one VS2005 is using if i have both SQL servers (2005 and
> Express) installed?
That is in the, eh, is it called Server Explorer? And you can work with
muiltiple servers.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|