Thanks much. This worked great.

How do you know that? The 4581 ms is in the Query Analyzer. I'm not measuring time to the page itself. Why does it take so long...

It takes 4581 ms to execute the query and 1 ms to execute the same w/ DataLength(Content)

Stephen

The length of the largest field is 256946. But I've worked on CMS systems w/ larger pages before. Any ideas?

Here's the table structure:

CREATE TABLE [dbo].[ContentManagement](

[ContentID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_ContentManagement_ContentID] DEFAULT (newid()),

[Content] [ntext] NOT NULL,

[PageName] [nvarchar](200) NULL,

[CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_ContentManagement_CreatedOn] DEFAULT (getdate()),

[CreatedBy] [int] NOT NULL,

[UpdatedOn]...

Thanks for your reply.

That SP is only called from the trigger. The SP checks the order database to see if the customer purchased a membership. The Customer record...

Sorry, I should have specifiied, I need a query that will work on both 2005 and 2000.

Stephen

Thanks Andras.

Can you give me a few examples of free tools that I might be able to try?

Thanks.

Stephen