SQL Management Studio and VS 2008
Fred Chateau
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
Erland Sommarskog
> 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.
From which setup did you try to install SSMS? That is, which edition and
version of SQL Server?
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.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/prodinfo/previousversions/books.mspx
Fred Chateau
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" <esq...@sommarskog.se> wrote in message
news:Xns9CDF72EF...@127.0.0.1...