In DELPHI code to determine whether the machine installed SQL Server Express Edition version?
Do not use SQL commands, be in namely ADO not connected to the front of the native SQL Server instance, determine whether the machine to install SQL Server Express Edition version?

CodePudding user response:

Look for SQL main program, check the version information of it?

CodePudding user response:

Check the registry should be a relatively simple way, such as
HKEY_LOCAL_MACHINE -- Microsoft -- Microsoft SQL Server Instance Names - there will be a default under the SQL Instance SQLEXPRESS, can be judged this is EXPRESS release

CodePudding user response:

refer to the second floor sololie response:

check registry should be a simpler way, such as
HKEY_LOCAL_MACHINE -- Microsoft -- Microsoft SQL Server Instance Names - there will be a default under the SQL Instance SQLEXPRESS, can be judged this is EXPRESS version

How the user when installing a SQL, the instance name is custom, could not find SQLEXPRESS key information

CodePudding user response:

You can also see the SQL sever service name

CodePudding user response:

Of course, the service name will certainly write registries, can look in registries in detail

CodePudding user response:

SELECT
SERVERPROPERTY (' productversion) as' the Product Version ',
SERVERPROPERTY (' productlevel) as' Patch Level ',
SERVERPROPERTY (' edition) as' the Product edition ',
SERVERPROPERTY (' buildclrversion) as' CLR Version,
SERVERPROPERTY (' collation) as' the Default collation ',
SERVERPROPERTY (" instancename ") as the Instance,
SERVERPROPERTY (' lcid) as "lcid",
SERVERPROPERTY (' servername) as' Server Name '

http://hi.baidu.com/liulin0712/item/73a8cbac91da99aa29ce9d41

CodePudding user response:

refer to 6th floor FRTRNR response:

SELECT
SERVERPROPERTY (' productversion) as' the Product Version ',
SERVERPROPERTY (' productlevel) as' Patch Level ',
SERVERPROPERTY (' edition) as' the Product edition ',
SERVERPROPERTY (' buildclrversion) as' CLR Version,
SERVERPROPERTY (' collation) as' the Default collation ',
SERVERPROPERTY (" instancename ") as the Instance,
SERVERPROPERTY (' lcid) as "lcid",
SERVERPROPERTY (' servername) as' Server Name '

http://hi.baidu.com/liulin0712/item/73a8cbac91da99aa29ce9d41

Help, on the top floor,