USE [MaybeNowStructure]

GO

/****** Object: Table [dbo].[Question] Script Date: 03/26/2009 16:49:16 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Question](

[ID] [bigint] IDENTITY(1,1) NOT NULL,

[UserID] [bigint] NULL,

[VisitorID] [bigint] NULL,

[Text]...

Thankyou very much for your valuable replies.

SQL Server Full Text Search is a keyword based search and I need to find the exact duplicate string which should then be removed...

I used the below mentioned query to find the DISTINCT records

SELECT DISTINCT Column1+cast(Column2 as varchar)

FROM TableName

it tooklong time

now I need to delete the duplicates and when...

basically the database is of a question/answer website so i have to do some maintenance on that DB and it has long text data so I need to find some...

My Pleasure !

Yes !

You can delete the DB files if you have stopped the main DB service.

Just delete the files or place it over some other server for analysis purpose...