VESSEA > Blog - DotNetNuke Clear Search Tables

Friday, July 30, 2010

Blog

DotNetNuke Clear Search Tables

Dec 17

Written by: Matthew Elgert
12/17/2009 7:17 PM

The following script is for clearing the DNN search tables.

/****** Object: StoredProcedure [dbo].[Util_ClearDnnSearchTables]    Script Date: 12/17/2009 19:27:31 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Util_ClearDnnSearchTables]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[Util_ClearDnnSearchTables]
GO

/****** Object: StoredProcedure [dbo].[Util_ClearDnnSearchTables]    Script Date: 12/17/2009 19:27:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- ==========================================================================================
-- Author:        Matthew David Elgert © 2009 VESSEA
-- Create date:   12/17/2009
-- Description:   Clear the DNN search tables
-- Reference: http://weblogs.asp.net/christoc/archive/2006/06/26/DotNetNuke-Daily-Tip-_2300_3-6_2F00_26_2F00_06-Clear-Search-Tables.aspx
-- http://www.vessea.com/Blog/tabid/58/EntryId/39/DotNetNuke-Clear-Search-Tables.aspx
-- THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND
-- CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES,
-- INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
-- AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
-- COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
-- SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
-- PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR
-- BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
-- CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
-- ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
-- DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
-- ==========================================================================================

CREATE PROCEDURE [dbo].[Util_ClearDnnSearchTables]
AS
BEGIN
      DELETE searchitemwordposition
      WHERE searchitemwordid IN (SELECT searchitemwordid
                                  FROM   searchitemword
                                  WHERE searchitemid IN (SELECT searchitemid
                                                          FROM   searchitem))

      DELETE searchword
      WHERE searchwordsid IN (SELECT searchwordsid
                               FROM   searchitemword
                               WHERE searchitemid IN (SELECT searchitemid
                                                       FROM   searchitem))

      DELETE searchitemword
      WHERE searchitemid IN (SELECT searchitemid
                              FROM   searchitem)

      DELETE searchitem
END

GO

Trackback Print

Location: Blogs

Matthew Elgert

DotNetNuke (WCM or CMS)

Tags:

0 comment(s) so far...

Your name:
Your email:
	(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:

Security Code Enter the code shown above in the box below
Add Comment Cancel

Privacy Statement