I had the same issue.

Read this: http://pyaarey.wordpress.com/2011/08/18/eventlog-error-initerrlog-could-not-open-error-log-file-operating-system-error-3the-system-cannot-find-the-path-specified/

Do it from the step 9. It worked by me.

(I added the SQL user to the SQLServerMSSQLUsers$<Machine>$<SQLInstance> group and it helped)

Bye,

Moha

I agree with you and i sorry my 2 points too 🙂

Sorry, I try on SQL 2000. Here is the plan:

But I understand now what happend on SQL2005 so thanks for you answer.

Now I see that why your choice is correct.

Moha

I don't belive it...

The server can use index when the first part of the index is in the where clause.

I try it and MS SQL server realy use index on...