SQL Management Studio and VS 2008 - 12-11-2009 , 06:23 PM
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?
Re: SQL Management Studio and VS 2008 - 12-12-2009 , 04:17 AM
Fred Chateau (fchateau (AT) community (DOT) nospam) writes:
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
Re: SQL Management Studio and VS 2008 - 12-12-2009 , 08:38 PM
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.
"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote