November 25, 2011 at 12:16 am
Hi,
I have checked for License information about SQL SERVER 2008, enterprise edition
SELECT CONVERT(char(20), SERVERPROPERTY('LCID'));
--1033
select convert(char(20), SERVERPROPERTY ('LicenseType'));
--disabled
SELECT CONVERT(char(20), SERVERPROPERTY('NumLicenses'));
--NULL
also checked at Registry as below
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100
Here MSSQLLicenseInfo folder name is not available. please tell me, how can an identified License type in SQL SERVER 2008 server?
Thanks
ananda
November 25, 2011 at 1:07 am
By the paperwork when you purchased SQL Server 2008. It is no longer (since SQL Server 2005) kept in the server. It is now all paper based. If you need to know how your SQL Server instance(s) are licnesed you will need to talk to some one in purchasing, perhaps. At a previous employer, they actually have someone whose sole job is to track software licensing such as this. If your organization is like that, then that is where you need to go.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply