One of our servers use SQL 7.0. This server has came accross with an error in the event viewer, application log as follows.
Source: LicenseService, Event ID: 202
The product Microsoft SQL Server 7.0 is out of licenses. Use License Manager from the Administrative Tools folder for more information on which users are out of compliance and how many licenses should be purchased.
When looking at the License Manager I found that we have 400/seat licenses and that we are using 416. I also found that I was was using about 15 of those licenses from about a month or so ago.
Now my question for you all is: Why is SQL retaining licenses for so long, and how do I get it to release them after the user has quite the session.