I have installed SQL Server 9.0.1399 ("SQL Server Standard Edition") on my
machine. I've also installed "Microsoft SQL Server Management Studio Express"
(because I couldn't find Microsoft SQL Server Management Studio NOT EXPRESS
ANYWHERE either in the SQL Server Install or to download from MS.com).

I was told that I could right-click on a database in the Managemebnt Console
and choose Tasks->Import Data. Yet when I go to Tasks, there is NO "Import
Data." There's Backup and Shrink and Detach, but no "Import Data." And I need
this!

Can someone please tell me what I'm doing wrong? DO I have the wrong version
of the SQL Management Console for 2005? If I do, can you please tell me
*exactly* where an MSDN Professional Subscriber can download it? All these
versions are makin' me NUTS!

Thanks!

Alex

Hi

SQL Server 2005 Management Studio is on Disk 2 of the distribution.
It is a selectable option during setup and is called "Workstation
Components".

If you run setup again, you will have the option to install the Workstation
Components, but un-install SSMS Express first.

SSMS 2005 Express has limited functionality as is intended to be used SQL
Server 2005 Express Edition (MSDE in SQL Server 2000)

Regards
Show quoteHide quote

Just a comment - I love MSFT and all of it's wonderful products. But you
realase so many levels of each of your products, with such confusing naming
and components, that it's impossible to know what there is, where it is, etc.

Alex


Show quoteHide quote

Hello Alex,

Though there are related information in Books Online or MSDN web site, I
agree it shall be very helpful if a centralized help inofmation on the
components of SQL 2005 included in readme files of setup CDs. Please rest
assured your feedback is taken seriourly and routed to the proper channel.

More related information on this issue:

922670    How to use the Add or Remove Programs item in Control Panel to add
or remove components for stand-alone installations and clustered
installations of SQL Server 2005
http://support.microsoft.com/default.aspx?scid=kb;EN-US;922670

909953    How to uninstall SQL Server Management Studio
http://support.microsoft.com/default.aspx?scid=kb;EN-US;909953

Thank you!

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Import Data succeeds but doesn't copy data?
SQL Server 2005 Management Studio vs. 2000 Enterprise Manager/Query Analyzer
SIMPLE command to convert string to number? Not CAST or CONVERT.
Cannot edit table data using Enterprise Manager
Maintenance plans not installed