Date1/5/2010 11:27:32 AM

LogJob History (Optimization job)

Step ID1

ServerMDSVSQL

Job NameOptimization job

Step NameOptimizing databases

Duration00:00:00

Sql Severity16

Sql Message ID22029

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

Executed as user: CUSTOMDIRECT\sqlservices. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The...

Model DB Maintenance Plan0, that's how I want to name file

I checked this is correct location

So, In 2000 we have option for optimization and integrity and in 2005 check db integrity replaces integrity job, what about optimization?Thank you

yes, I get this error message:

Login failed for user 'CUSTOMDIRECT\sqlservices'. [CLIENT: <local machine>] how can I find out what is this

job ran in past, I have spase and this id full mode

I already have AWE check and I have Standard Edition.

It's also required for AWE memory which, since SQL 2000 has no x64 edition, you need to be using to access...

I read the articles,but I still would like to know if I check this option to true Lock pages in memory will this increase a perfomance? Also it is is...

Thank you

Thank you

This is what I get:

Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on...

Thank you for the articles

Yes,Iwas told our LockPage setting in memory needs to be set to true, but wehere is it? Thank you

It is a lock page setting in memory, If I turn on, it will increase our performance

I was told there is a switch on sql server that needs to be turn on to increase perfomance on sql server