DNN 6.1.2 HTML Editor Issue From 5.6.2/3 Site Upgrade
Posted: December 21, 2011 Filed under: DotNetNuke (DNN) Leave a commentI have run into HTML editor issue with two upgrades from 5.6.2/5.6.3 to 6.1.2. The merged web.config file after upgrade still use the previous HTML editor: FckHtmlEditorProvider. You need to switch this to DotNetNuke.RadEditorProvider to make the rich text editor to work.
Here is the correct entry in web.config file:
<htmlEditor defaultProvider=”DotNetNuke.RadEditorProvider”>
<providers>
<clear />
<add name=”DotNetNuke.RadEditorProvider” type=”DotNetNuke.Providers.RadEditorProvider.EditorProvider, DotNetNuke.RadEditorProvider” providerPath=”~/DesktopModules/Admin/RadEditorProvider” />
</providers>
</htmlEditor>
Edit:
Another way to do this is from Host>>HTML Editor Manager to switch the Editor to DotNetNuke.RadEditorProvider
SQL Server Maintenance Automation Routines By Ola Hallengren
Posted: December 13, 2011 Filed under: SQL Server, SQL Server 2005, SQL Server 2008 Leave a commentI came across to these free maintenance automation routines written by Ola Hallengren a few month ago but without using it. After reading Paul S Randal’s recommention, I have played around with it and adopted it to my new database server and I like it.
Here is the web address of Ola Hallengren’s website and you can download the routines in a single download:
Change All Databases Compatibility Level to 100 (SQL Server 2008)
Posted: December 8, 2011 Filed under: SQL Server 2008 Leave a commentEXEC sp_MSForEachDB
‘
ALTER DATABASE [?]
SET COMPATIBILITY_LEVEL = 100;
‘
Generate Script to Modify Logical name of databases
Posted: December 8, 2011 Filed under: SQL Server, SQL Server 2005, SQL Server 2008 Leave a comment–Generate a set of Alter Database command to modify Logical name of Database
–Jingyang Li 12/07/2011
SELECT CASE
WHEN a.name <> b.name
AND a.name + ‘_log’ <> b.name
THEN ‘ALTER DATABASE [‘ + a.name +
‘] MODIFY FILE (NAME= [‘ + b.name + ‘] ,NEWNAME= [‘ +
CASE WHEN fileid = 1 THEN a.name +’]’ ELSE a.name + ‘_log]’ END + ‘ )’
ELSE ”
END
FROM sys.sysdatabases a
INNER JOIN sys.sysaltfiles b
ON a.dbid = b.dbid
WHERE a.dbid > 4
Change Database Owner in SQL Server
Posted: December 8, 2011 Filed under: SQL Server 2005 Leave a commentALTER AUTHORIZATION
ON Database :: myNewDB To [myDomain\uName]