Determine MS SQL License Mode on Wintel Servers

[markhpe]

Hi there.

I am trying to remotely determine the license mode that was used when installing MS SQL (versions 6, 7 and 2000) on a remote server. I do not have a SQL logon and thus am asking is there a file / registry entry that can tell one if SQL was installed PERSEAT or PERSERVER?

Any help would be greatly appreciated as I have tried searching google and have not found anything.

[iburyak]

I don't think software license information is available through software installation.

All server available information can be seen by executing:

sp_server_info

[markhpe]

Hi there. No Licensing mode information is available from sp_server_info

Any other stored procedures?

[iburyak]

As I told you above it is not available.

[SLINKTMP]

I understand what you are looking for. In an enterprise environment, it is necessary to audit your servers for licenses. You might acquire servers from other departments or even other companies that were built prior to you having ownership of them. An audit is necessary to not only see what version of SQL server is on a machine but also if it is licensed using per seat or per processor (and how many).

Does anyone know a command or stored procedure to reveal this data? Thanks.

[LovermanRon]

Sorry iburyak ...but you are wrong

SELECT SERVERPROPERTY('LicenseType') returns the license mode in all versions except 2005