Determine MS SQL License Mode on Wintel Servers

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.I don't think software license information is available through software installation.

All server available information can be seen by executing:

sp_server_info|||Hi there. No Licensing mode information is available from sp_server_info

Any other stored procedures?|||As I told you above it is not available.|||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.

Detect Licensing

Hello

I am trying to find out if versions of SQL SERVER 2005 we have installed have full or Developer Licenses.

They were installed previously by someone who no longer works here, and we do not the versions on record.

We have enough full licenses, so we just want to make sure the correct ones are set up on our servers.

Anyone know how/where we can find this information?

I found the answer - SELECT @.@.version

Thanks

Desupport dates

Is the a page online that lists any desupport dates for
the various versions of SQL Server (v7, 2000 etc)http://support.microsoft.com/defaul...en-gb;lifeprods
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:b62101c407bb$afa9b4f0$a401280a@.phx.gbl...
> Is the a page online that lists any desupport dates for
> the various versions of SQL Server (v7, 2000 etc)