如何知道我的系统中安装了多少sql sever实例？ [英] how to know how many sql sever instances are installed in my system?

问题描述

您好，



在我的系统中，我安装了带有sql express版本的visual studio 2010，之后我安装了sql server 2008完整版，但是当我连接时到服务器它只显示sql express。我想知道如何连接sql server。



谢谢。

Hello,

In my system I have install visual studio 2010 with sql express edition and after that I have install sql server 2008 full edition but when I am connecting to server it only shows sql express . I want to know how to connect sql server.

Thank You.

推荐答案

如果你想从代码执行此操作，使用SMO： http：// msdn .microsoft.com / zh-CN / library / ms210425（d =轻量级，v = sql.105）.aspx [ ^ ]

如果你想亲自检查一下，转到服务管理工具，然后在SQL Server之后，每个实例都有实例名称。请注意，默认实例（未命名）列为MSSQLSERVER。

If you want to do this from code, use SMO: http://msdn.microsoft.com/en-us/library/ms210425(d=lightweight,v=sql.105).aspx[^]
If you want to check it for yourself, go to the Services management tool, and there you will have every instance with instance name after "SQL Server". Note that the default instance (unnamed) is listed as MSSQLSERVER.

您好，



您可以使用





select * from sys.servers



现在你可以获得你可以访问的所有实例像local和remot连接服务器一样

Hi ,

you can use


select * from sys.servers

now you can get all instances u can accesses like both local and remot connection servers

这篇关于如何知道我的系统中安装了多少sql sever实例？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！