Update Ektron License

Posted on By David Kittell

After applying this update you will need to restart the services and in some case restart the server completely.

SELECT lic_key
FROM Settings

SELECT module_license
FROM module_licenses

UPDATE Settings
SET lic_key = '<License>'

UPDATE module_licenses
SET module_license = '<License>'
Originally Posted on July 19, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code Ektron MSSQL MSSQL - Ektron MSSQL - Ektron 8.0.2 SQL

Related Posts

Embarcadero Delphi – Battery Indicator/Check

Posted on

If your application runs on a computer or device that has a battery it’s helpful to know the battery level. Setup your application canvas with 3 labels, 1 Gauge (progress bar) and 1 timer. To keep it simple I’m not changing the names of the elements so you should have:…

Read More

PHP Create MySQL Table From CSV File Headings

Posted on

$handle = fopen("test.csv", "r"); // Read first (headers) record only) $data = fgetcsv($handle, 1000, ","); $sql= ‘CREATE TABLE table_name (‘; for($i=0;$i<count($data); $i++) { $sql .= $data[$i].’ VARCHAR(50), ‘; } //The line below gets rid of the comma $sql = substr($sql,0,strlen($sql)-2); $sql .= ‘)’; echo $sql; fclose($handle); Reference: https://bytes.com/topic/mysql/answers/746696-create-mysql-table-field-headings-line-csv-file All information…

Read More

Azure – MSSQL Server Information

Posted on

Same as MSSQL Server Information but is specific to what will work in Azure — Basic Information SELECT @@Servername AS [Server Name] –,@@ServiceName AS [Service Instance] ,Name AS [Database Name] ,create_date AS [Service Started] ,DATEDIFF(s, create_date, GETDATE()) / 86400.0 AS [Days Running] ,DATEDIFF(s, create_date, GETDATE()) AS [Seconds Runnig] ,@@VERSION AS…

Read More