Category: MSSQL
Delete Ektron User
In order to force a deletion from the Ektron user list you must follow the below path. DISCLAIMER: This will remove all content that was ever created/touched by the user.
Update Ektron License
After applying this update you will need to restart the services and in some case restart the server completely.
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
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.