This script will search and replace specific library links Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
This script will search and replace specific content/phrases through the entire content table. This script can be modified to handle different scenarios as well. Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
Based Off of Ektron Code Library – http://developer.ektron.com/Templates/CodeLibraryDetail.aspx?id=4294967329&blogid=116
Following the logic in a previous post, File Extension, this query will list Ektron asset file extensions and count them.
If you are working in a database that has asset/file storage and need to get just the extension of the column this query will help save time.
Reference: http://msdn.microsoft.com/en-us/library/ms170572.aspx