1. look in services. Is it set for Automatic or Manual start (or worse yet...disabled)

2. In cluster admin, is it set for any dependancies? Compare it to the other instance's...

Remi,

I knew it was a scan, but the poster is already doing: LIKE '% myword %' and LIKE '% myword', which would use scans.

I also knew about the oneofmywords issue,...

If you have to do it via TSQL, look up CONVERT in the BOL.  You will have to CONVERT to money and then to VARCHAR.

CONVERT(VARCHAR(20), (CONVERT(MONEY, 13965.00)), 1)

-SQLBill

Check out this article, by Chris Kempster, about moving databases....you can use the syntax he provides, just use the MOVE with the log file and not the .mdf.

http://www.sqlservercentral.com/columnists/ckempster/deattachandreattachdatabases.asp

-SQLBill

Read this article, by Steve Jones, about moving TEMPDB:

http://www.sqlservercentral.com/columnists/sjones/atemporarymove.asp

As for moving the logs, just detach the database, reattach using the WITH MOVE option. Refer to the BOL for more information.

-SQLBill

Why not just do:

select * from task

 where Descr LIKE '%myword%'

-SQLBill

Just out of curiosity, what SP level is your SQL Server 2000?

-SQLBill

Look through the Windows Event Viewer logs for any related error messages. Also, how are the job steps set up for if they fail? If the first step (deleting the...

Check your jobs...see if there is one running at that time that includes the detach command.

-SQLBill

DON'T delete the .mdf and .ldf files. Just rename the extension (i.e.  mydb.mdf.old).

That way you still have them. Then do as suggested above, but when you detach the restored db,...

What was your solution? (It might help someone else at a later date).

-SQLBill

If I understand you correctly, you are searching through a table/column that has lots of product Ids, but you really only need to retrieve data from 7 product IDs. If...

The BOL is really a help tool that comes with SQL Server...but you can download it from Microsoft's site. Here's where you can find it:

BOL=Books OnLine=Microsoft SQL Server's HELP

Installed as...

Check the SQL Server Error log and the Windows Event Viewer Logs for any related error messages. Your connection might be timing out.

Are you sure you are passing the correct...

By the way.....this '2000.80.194' indicates your SQL Server is version 2000 and is NOT patched. 194 is the Release to Manufacturer build.  You should be patched to at least Service...