This script will remove all HTML tags from a given column in a table, useful if you need to simply have the text. Source: http://blog.sqlauthority.com/2007/06/16/sql-server-udf-user-defined-function-to-strip-html-parse-html-no-regular-expression/
When integrating various systems you sometimes need to convert DateTime values to an Integer, the code samples below will be helpful
Source: http://www.codeproject.com/Articles/275767/Ektron-SQL-Script-To-Clone-A-Menu-into-Multiple-La
The following files and folders are pre-installed/configured by the Ektron site setup. Most of them can be configured through the web.config. FOLDERS %WebRoot%/Assets/ DMS storage location of public uploaded assets %Drive%:/%CustomPath%/AssetLibrary/%SiteName%/ DMS storage location defined during site setup %WebRoot%/AssetManagement/ DMS application files used to upload/view DMS assets %WebRoot%/UploadedFiles/ Where the uploaded files are saved %WebRoot%/UploadedImages/…
This script will display the current Ektron version. Works In: 8.0.2, 8.5, and 8.7 Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
This script will rename template paths Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
This script will rename folder paths of renamed CMS folders. Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
This script will rename manual aliases Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
This script will rename menu link paths Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
This script will search and replace sitemap links/titles/etc Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx