After applying this update you will need to restart the services and in some case restart the server completely.
Category: SQL
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.