Post reply

Sql 2008 license query

  • October 6, 2010 at 9:18 am

    #227315

    Is there a query I can run for Sql 2008 to find out if a server is licensed under per processor or by per seat?

  • October 6, 2010 at 9:23 am

    #1232707

    No.

  • October 6, 2010 at 9:32 am

    #1232720

    thanks,

    is there a query for maximum number of concurrent connections?

  • October 6, 2010 at 9:36 am

    #1232723

    Actually there is:

    select SERVERPROPERTY('Edition') as [Edition],

    SERVERPROPERTY('LicenseType') as [License Type],

    SERVERPROPERTY('NumLicenses') as [# of Licenses]

    edit: disregard..apparently this doesn't work, since the installer no longer puts license info in the registry.

  • October 6, 2010 at 11:33 am

    #1232863

    amdavis (10/6/2010)

    thanks,

    is there a query for maximum number of concurrent connections?

    The maximum connections can be viewed by running this script on SQL Server.

    --------------------------------------

    exec sp_configure 'show advanced' , 1

    reconfigure with override

    go

    exec sp_configure 'user connections'

    --------------------------------------

    0 is default and means "unlimited". Unlimited means 32767 concurrent connections.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply