比在系统上设置的sqlexpress更了解? [英] How understand than sqlexpress setuped on a system?

问题描述

你好

比在系统上设置的sqlexpress2008更了解?

hello

How understand than sqlexpress2008 setuped on a system?
or not setuped yet

推荐答案

可以使用多种方法来检查是否安装了特定的应用程序.最简单的方法是，您可以在控制面板->添加/删除程序''-如果已安装程序，则应该可以从此处进行卸载.


如果您想通过代码进行检查，请查找此处-示例VB.NET [ ^ ]

There can be various ways in which you can check if a particular application is installed or not. Easiest would be, you can check in ''Control Panel -> Add/Remove programs'' - if program is installed, you should be able to uninstall from there.


In case, you want to check it via code, look here - example VB.NET[^]

如果要检查SQL Server是否可用，请使用

If you want to check that if SQL server is available then use SqlDataSourceEnumerator[^] as Mika said and if you want to see if they are express version or not try to run this query on them :

select @@VERSION

如果输出字符串中有Express Edition，则它应该是快速版本.

但是也可以考虑从第三方为您的程序使用安装程序，因为它们可以处理您程序的所有先决条件，并且您将不再担心此问题.

If there was and Express Edition in output string then it should be an express edition.

But also consider using an install program for your program from third parties because they handle all prerequisites for your program and you will not worry for this issues any more.

问题不是很清楚，但是您可以使用控制面板从Windows服务检查例如SQL Server服务是否存在.

如果要以编程方式执行此操作，则可以使用例如 SqlDataSourceEnumerator [^ ]列出所有现有实例.

并且可能(取决于您的需求)，您可以简单地尝试使用连接到实例SqlConnection [ ^ ]

The question is not quite clear but you can check for example from Windows Services using Control Panel if SQL Server service exists.

If you want to do this programmatically, you can use for example SqlDataSourceEnumerator[^] to list all existing instances.

And possibly (depending on your needs) you can simply try to connect to an instance using SqlConnection[^]

这篇关于比在系统上设置的sqlexpress更了解?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！