I'm a little confused about running SQL Express with VS 2008.

VS 2008 installed SQL Express as part of normal installation, but it only
installed the SQL Server engine and Configuration Tools. I would like to
have a copy of SQL Management Studio on my machine, but I didn't want to run
a complete installation of SQL Server. I thought I could install the Client
Workstation Tools and that would give me a copy of SQL Management Studio,
but the installer said that the client tools were already installed.

What am I missing here? The bottom line for me is that I needed to attach a
database in SQL Express, but there doesn't seem to be a way to do it. To be
clear, I am not talking about attaching a database file, but rather
importing a database into SQL Express. Can this be done in VS 2008
Professional Server Explorer?

--
Regards,

Fred Chateau

Fred Chateau (fchateau (AT) community (DOT) nospam) writes:
From which setup did you try to install SSMS? That is, which edition and
version of SQL Server?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

I got it solved.

I tried to use SQL Server 2008 Enterprise, and it kept bombing out. I
switched to Standard Edition, and it installed properly.

--
Regards,

Fred Chateau


"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote