we have a SQL7 database which our admin staff use. at present we dont have enough licenses to go around (managment dont want to spend the cash.....), so at busy times one person may have to wait for another to log off.

SQL appears to be "locking" a SQL license to an NT logon, even if the user logs off of the NT server the lock still exists. The only way to free up the license for another user is to restart the SQL services....

does anyone know if it is possible to stop SQL locking the licenses to the NT logons??

thanks

n