.net SQL Server Management Studio 是否附带 Visual Studio？

Does SQL Server Management Studio come with Visual Studio?

提问by Not So Sharp

I have the full Visual Studio 2010 (not express) installed, with SQL Server that came with it as well:

我安装了完整的 Visual Studio 2010（不是 express），还安装了 SQL Server：

I was trying to locate SQL Server Management Studio (ssms) in order to follow this tutorialbut I can't seem to find it in my installation.

我试图找到 SQL Server Management Studio ( ssms) 以便按照本教程进行操作，但我似乎无法在我的安装中找到它。

I could theoretically download the 2008 Management Studio Expressbut given the so many editions and versions of SSMS (e.g. 2012 Express), how do I know whether it is compatible with my VS 2010?

理论上我可以下载2008 Management Studio Express但鉴于 SSMS 的版本和版本如此之多（例如2012 Express），我怎么知道它是否与我的 VS 2010 兼容？

Also, why download an Express Edition if I already have it in my original Visual Studio 2010 DVD?

另外，如果我的原始 Visual Studio 2010 DVD 中已有 Express Edition，为什么还要下载它？

So my questions are:

所以我的问题是：

1. Is SSMS already installed but I don't see it? (if so, how do I locate it?)
2. If it's not installed, do I just need to run Setup again, then install it?
3. If it isn't really on the VS 2010 DVD (as many on SO suggest), which downloadable Express edition is most compatible with my VS 2010 (not express)?

1. SSMS 是否已安装但我看不到它？（如果是这样，我如何找到它？）
2. 如果没有安装，我是否只需要再次运行安装程序，然后安装它？
3. 如果它不是真的在 VS 2010 DVD 上（正如 SO 建议的那样），哪个可下载的 Express 版本与我的 VS 2010（非 Express）最兼容？

Update:(for the benefit of future MS SQL Server newcomers)

更新：（为了未来的 MS SQL Server 新人的利益）

Thanks to the answers below I managed to successfully install what I needed and most importantly understandthe tools picture.

多亏了下面的答案，我成功地安装了我需要的东西，最重要的是理解了工具图片。

So to answer my particular questions one by one:

所以要一一回答我的特定问题：

1. No
2. No
3. SQL Server Management Studio 2008Express

1. 不
2. 不
3. SQL Server Management Studio 2008Express

Tips:

提示：

1. Once everything is installed, the next question is "What do I do next?". Fortunately, there is a great tutorialwhich to me is much clearer than the cumbersome (repetitious, cyclic links, non-linear, etc.) official Microsoft documentation.
2. Despite the greatness of the functionx.com tutorial, it doesn't provide enough details on how to initially connect to local. Once again, SO comes to the rescue and clarifies that 2 more conditions must be met: (a)SQL Server Browserservice must be running. (b)Server name must not be "local" but rather <local-pc-name>\SQLEXPRESS.
3. To programmatically create a database in C#, use ADO.NETas well.
4. Whyuse schemas.
5. Don't even think about storing database files on a network share.
6. If you get "Invalid object name" in a SELECT statement for a table you just created, refresh the local cache.
7. When encountering System.Data.SqlClient.SqlExceptionfor the first time you use C# with an existing database using new SqlConnection(), remember that "Data Source=" cannot specify the computer name alone (as in the tutorial) but rather have \SQLEXPRESS appended to the computer name. Also, make sure TCP/IP Client Protocolis enabled.

1. 安装完所有内容后，下一个问题是“下一步我该怎么做？” . 幸运的是，有一个很棒的教程对我来说比繁琐（重复、循环链接、非线性等）的Microsoft 官方文档清晰得多。
2. 尽管 functionx.com 教程很棒，但它没有提供足够的关于如何最初连接到本地. SO 再次出手相救，并澄清必须满足另外 2 个条件：(a)SQL Server Browser服务必须正在运行。(b)服务器名称不能是“local”，而是<local-pc-name>\SQLEXPRESS.
3. 要在 C# 中以编程方式创建数据库，也可以使用ADO.NET。
4. 为什么使用模式。
5. 甚至不要考虑将数据库文件存储在网络共享上。
6. 如果在刚创建的表的 SELECT 语句中得到“无效对象名称”，请刷新本地缓存。
7. 当System.Data.SqlClient.SqlException您第一次使用 C# 使用现有数据库时new SqlConnection()，请记住“Data Source=”不能单独指定计算机名称（如教程中所述），而是将 \SQLEXPRESS 附加到计算机名称。此外，请确保启用TCP/IP 客户端协议。

采纳答案by SchmitzIT

SSMS is for running queries and performing database administration tasks, etc. Configuration manager is a configuration tool for SQL Server, where you can configure (Start/Stop/user credentials, etc.) the services used by SQL Server.

SSMS 用于运行查询和执行数据库管理任务等。配置管理器是 SQL Server 的配置工具，您可以在其中配置（启动/停止/用户凭据等）SQL Server 使用的服务。

However, installing Visual Studio does not mean you get the full version of SQL Server, but you get the Express edition, which does not include SSMS.

但是，安装 Visual Studio 并不意味着您获得 SQL Server 的完整版本，而是获得 Express 版本，其中不包括 SSMS。

Maybe this MSDN linkwill help.

也许这个 MSDN 链接会有所帮助。

回答by David Kroukamp

As said by bugfinder and others (+1 to all) sql management studio and sql configuration manager are not the same.

正如bugfinder和其他人（+1）所说，sql管理工作室和sql配置管理器不一样。

It doesn't matter which visual studios version you have.

您拥有哪个 Visual Studios 版本并不重要。

What matters is the sql server version you have. I.e You have sql server 2008 installed thus you should download management studio for sql server 2008. ( you have the link in your question). I have vs 2010 ultimate and it didn't have management studio incorporated.

重要的是您拥有的 sql server 版本。即您安装了 sql server 2008，因此您应该下载 sql server 2008 的管理工作室。（您在问题中有链接）。我有 vs 2010 Ultimate 并且它没有包含管理工作室。

回答by BugFinder

No configuration manager is for configuring how your SQL server allows connections. There is still an "SQL Server Management Studio" for queries etc

没有配置管理器用于配置 SQL 服务器允许连接的方式。还有一个用于查询等的“SQL Server Management Studio”