Sometimes you’re asked where a DMS file exists on the server and have to track it down, this query should help. Caveat: It helps to know where your root/main asset directory is on your server.
Category: SQL
Remove HTML Tags
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/
Clone A Menu Into Multiple Languages
Source: http://www.codeproject.com/Articles/275767/Ektron-SQL-Script-To-Clone-A-Menu-into-Multiple-La
Ektron Current Version
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
Ektron Rename Templates
This script will rename template paths Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
Ektron Find Replace Library Folder Names
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
Ektron Find Replace In UrlAliasManual
This script will rename manual aliases Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
Ektron Find Replace In Menu
This script will rename menu link paths Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx