How to Shrink Your DotNetNuke Database Log File / Truncate Transaction Log

DNN Expert posted on December 31, 2011 08:05

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...]

Posted in: DotNetNuke, Microsoft SQL Server, SQL Server 2008 R2

Actions: E-mail | Permalink | Comments (0)

07

SQL Linked Server Error

DNN Expert posted on October 07, 2011 07:01

To work around this problem, follow these steps on the computer that Windows Server 2003 or Windows XP SP2 is installed on: Make sure that the ...

[Read the rest of this article...]

Posted in: Microsoft SQL Server

Actions: E-mail | Permalink | Comments (0)

09

Sample Connection Strings

DNN Expert posted on August 09, 2011 05:12

Oracle: "Provider=MSDAORA; Data Source=ORACLE8i7;Persist Security Info=False;Integrated Security=yes" Microsoft Access: "Provider=Microsoft.Jet.OLEDB...

[Read the rest of this article...]

Posted in: Microsoft SQL Server, Web.Config

Actions: E-mail | Permalink | Comments (0)

10

DNN User Login report SQL script for DNN Reports Module

DNN Expert posted on April 10, 2011 13:27

Here's a great sql script to use for the DotNetNuke Reports Module: Select AU.Username, U.FirstName, U.LastName, AM....

[Read the rest of this article...]

Posted in: DotNetNuke, Microsoft SQL Server, SQL Scripts, Core Modules

Actions: E-mail | Permalink | Comments (0)

17

Finding the Port of MS SQL Named Instance

DNN Expert posted on March 17, 2011 06:12

When running a named instance of MS SQL the instance will run on a port other than the usual port 1433. To determine the port you can use th...

[Read the rest of this article...]

Posted in: Microsoft SQL Server, Stored Procedures, SQL Server 2008 R2

Actions: E-mail | Permalink | Comments (0)

09

Farming Leads Import

DNN Expert posted on January 09, 2011 07:26

INSERT [dbo].[Farming] ( [First Name] [Last Name] Title [Mailing Address] [Mailing City] [Mailing Province/State] [Mailing Postal/ZIP] We...

[Read the rest of this article...]

Posted in: Microsoft SQL Server

Actions: E-mail | Permalink | Comments (0)

20

Create a New Database From an Existing Database Backup (SQL Server Management Studio)

DNN Expert posted on December 20, 2010 07:52

This topic explains how to create a new database from an existing full database backup. Security Note ...

[Read the rest of this article...]

Posted in: Microsoft SQL Server, SQL Server 2008 R2

Actions: E-mail | Permalink | Comments (0)

30

SQL SPLIT Function

DNN Expert posted on April 30, 2010 05:15

Add the helper SPLIT function to your database CREATE FUNCTION dbo.Split ( @List nvarchar(2000), @SplitOn nvarchar(5) ) RETURNS @RtnVal...

[Read the rest of this article...]

Posted in: Microsoft SQL Server

Actions: E-mail | Permalink | Comments (0)

12

SEO Content Pages

DNN Expert posted on March 12, 2010 08:31

PROCEDURE GIBS_SEO_Content nvarchar(50) = null AS BEGIN if (len(@city)=0) begin set @city=null end SET NOCOUNT ...

[Read the rest of this article...]

Posted in: Microsoft SQL Server

Actions: E-mail | Permalink | Comments (0)