Hi Gail & Christopher,

Many thanks for your replies, greatly appreciated!

The production server I have is a remote SQL Server 7 that I do not have a major control over (ISP...

It is SQL Server 2005.

I'm thinking that the way I'm storing the keywords is probably not the best way to achieve this!

Even if you do a basic search on the...

Hi,

Many thanks for replying!

I thought that should work, however, I'd already tried this and it returns no records!

The logicl OR is fine, i.e. give me a page if the word...

Thank you for the update, greatly appreciated.

Mike

Hi,

The value is important as it needs to match a database in the States I'm mirroring!

I have sorted it...

I deleted the 10 entry and then executed the following code:

SET IDENTITY_INSERT...

Hi, Apologises for the delay in replying!

Unfortunately, it was so long ago when I had this issue I cannot recall the full story of how I cured it !!!

I suspect...

Sorted it out !

Use database_name

GO

ALTER DATABASE database_name SET SINGLE_USER

GO

DBCC CHECKDB('database_name', REPAIR_REBUILD)

GO

Thanks...Mike

Perfect Greg,

Works a treat, thank you very much.

Mike D

Thanks, will up the memory, cheers. Mike

Hi,

We still experience the problem every now and again, however, we have discovered that we have minimised it by the following:

1. On your IIS server add the following accounts to...

Thanks for the replies, the database is 99.1 MB with approx 23GB of free disk space.

Thanks.

Mike

Hi, I think it was a combination of things!

Firstly, security privileges

Secondly, this particular DTS was the last of 4 to run, on successful compilation of these it sends a MAPI...

Thankyou for you replies, the E: drive is a second partition on the same disk within the server !

I have the following to try tonight to see if this works...

Hi,

The HTMLEncode worked fantastic !!!!!

Thanks very much.

Mike

Hi,

I looked a little further into this and it appears that the SQL side is ok.

It is simply the <TEXTAREA that converts HTML special symbols!

In the URL I have &section=k

&sect...