SQL Server 2005 + SQL Server Express

[farseer]

Hi,
I have SQL Server 2005 installed on my dev system. I am working on an
app that i would like to distribute SQL Server with. SQL Server
EXpress edition seem to be ideal for this. My questions are:

-If i installed Express Edition, Can both SQL Server 2005 and Express
Edition coincide peacefully on the same PC?

-Which one will Visual Studio see? (currently i created by database
using VS, which i assumed created a SQL Server 2005 database, since
that is the sql server i have installed).

-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?

thanks much

[Erland Sommarskog]

farseer (fa*****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[farseer]

Thank you..