Code | Ektron | MSSQL | MSSQL - Ektron | MSSQL - Ektron 8.0.2 | SQL
Update Ektron License
After applying this update you will need to restart the services and in some case restart the server completely.
-
-
Code | Ektron | Ektron User Management | MSSQL | MSSQL - Ektron | MSSQL - Ektron 8.0.2 | MSSQL - Ektron 8.7
Ektron SQL – List All Users
If you’re looking for more specific access lists look at Ektron – User Access List
-
-
-
Convert Text to VarChar
Example: IP is varchar(50) and Hostname is Text Not sure why you would ever have a need for this but this is an example that works. More practical use
-
SQL Statement Validator
Reference: http://stackoverflow.com/questions/3276035/code-to-validate-sql-scripts
-
Alter Table
With this statement you would need to make sure that the column you wish to change does not currently have NULL values before running it otherwise you will likely have errors. With this statement you need to make sure that the column you wish to change only has unique values
-
-
-
Code | Ektron | Ektron User Management | MSSQL | MSSQL - Ektron | MSSQL - Ektron 8.0.2 | MSSQL - Ektron 8.7 | SQL
Ektron Metrics – User Count By User Group
Part of the Ektron Metrics Script, this query will help with metrics to give you an idea of how often your users login.