Re: Sqlmaint.exe problem

Do you mean it runs and doesn't do anything or simply doesn't run?
Personally I would just forget about sql_maint and create your own job to do
the check. If you are talking about integrity checks then just create a job
that runs

DBCC CHECKDB
DBCC CHECKCATALOG


--
Andrew J. Kelly SQL MVP


"Olav" <Olav@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BA6F6483-B0BA-48A6-9E1F-34B3F7EDD954@xxxxxxxxxxxxxxxx
> It does not give any messages no matter what switches we use. Even no
> response back when we use the -? switch.
>
> "Andrew J. Kelly" wrote:
>
>> That's not much to go on. Can you be more specific than "it will not run
>> properly"?
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>>
>> "Olav" <Olav@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:F0328CFA-59C7-4546-8099-57B671E7425E@xxxxxxxxxxxxxxxx
>> > Hi we have an database check routine based on sqlmaint. This works fine
>> > on
>> > most machines but on my customers Windows 2000 machine i will not run
>> > properly. It will not even show the switches using sqlmaint -?
>> > Any idea?
>> > Regards,
>> > Olav
>> >
>>
>>
>>


.

Relevant Pages

  • Re: Distributed transaction
    ... Do you have DTC running on both machines? ... Andrew J. Kelly SQL MVP ... Distributed transaction ...
    (microsoft.public.sqlserver.programming)
  • Re: Sqlmaint.exe problem
    ... Andrew J. Kelly SQL MVP ... > Hi we have an database check routine based on sqlmaint. ... > most machines but on my customers Windows 2000 machine i will not run ...
    (microsoft.public.sqlserver.tools)
  • Re: Sqlmaint.exe problem
    ... It does not give any messages no matter what switches we use. ... > Andrew J. Kelly SQL MVP ... >> Hi we have an database check routine based on sqlmaint. ... >> most machines but on my customers Windows 2000 machine i will not run ...
    (microsoft.public.sqlserver.tools)
  • Re: Extremely high % Disk Time .. How is this possible??
    ... Andrew J. Kelly SQL MVP ... > Slicing them into logical drives may look better but it does not increase ... I prefer to look at disk queue ... >>> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Performance really poor if calling data from sql clients
    ... Andrew J. Kelly SQL MVP ... The TCP connection is running from the client ... On a computer running the test which is not the database hosting ...
    (microsoft.public.sqlserver.clients)