PROCEDURE: This article tells you how to shrink a DotNetNuke database’s log file via Microsoft’s SQL Server Management Studio. 1) Lo...

[Read the rest of this article...]

ldf, logfile, sql log, truncate, shrink database, full transaction log error

To capture the IP address of the user submittings a DNN Form and List form add a new column called "IP Address", type = Text, Display on Lis...

[Read the rest of this article...]

Form and List, FNL, UDT, User Defined Table

DNN module skin container settings are stored in the TabModules table. Use the following SQL statement to reset all containers: update TabModules s...

[Read the rest of this article...]

The Address Resolution Protocol (ARP) is very crucial for TCP/IP network communication. If you begin to notice network connectivity problems such as p...

[Read the rest of this article...]

In Windows Server 2008 Core installation, the only way to setup IP Address eithe Static or DHCP is from the command line. The following procedure help...

[Read the rest of this article...]

Windows Server 2008

Command Line Fix NOTE: If you use this method, you may turn off the autotuning feature for the Server service. To change the default time-out per...

[Read the rest of this article...]

Upon startup, when prompted to enter the Adaptec Embedded SATA HostRAID BIOS, press the CTRL+A keys.   In the Adaptec Embedded SA...

[Read the rest of this article...]

Hardware Configuration

http://support.microsoft.com/kb/839279

[Read the rest of this article...]

SQL, Network DTC Access

In DotnetNuke Localization support, every resource key (in APP_LocalResources or APP_GlobalResources) should end with an extension. resourceName.T...

[Read the rest of this article...]

To format a short date like MM/DD/YY try the following: select CONVERT(VARCHAR(8), GETDATE(), 1) as MyShortDate For a complete guide to&nb...

[Read the rest of this article...]

SQL, Date, Convert