Recently I had to transfer ICD9CM codes from one database to another with limited database permissions, I decided to let the database work for me to perform the task. Ideally you’d have Visual Studio SSIS or some other mass data transfer option but this query will help you to get the data across. One thing…
Reference: http://technet.microsoft.com/en-us/library/aa259221(v=sql.80).aspx
In the recent upgrade from Ektron 8.0.2 to 8.7 I’ve been rebuilding forms to user controls that can be used as widgets. Below is basic elements to make the form work for your Ektron 8.7 (possibly higher). Please note the TextBox SubmissionEmail, this allows you to change the email address that the form goes to…
This should only be done on a development computer, doing so on a production server would not be good. Please note that while stopping the services I’m also setting the start command to “demand” this is also known as “manual”. In setting this command Ektron will no longer automatically start with the computer. Please note…
Similar to MSSQL – Table/View Column Information, this post will help with MySQL tables and columns. This query is a quick query to give you the pertinent information about a specific table.