Error Message 22029 on SQL Server 2005

Hello
I have a problem with the SQL Server 2005
This is the Version i am using:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
On the Server in the SQL Management Studio in a Query Window i execute the
command:
exec master..xp_sqlmaint '-D
kunde -WriteHistory -CkDB -CkAl -CkCat -RebldIdx 10'
this is the output i get.
output
----
NULL
Microsoft (R) SQLMaint Utility (Unicode), Version 9.00.1399.06
Copyright (c) Microsoft Corporation.
NULL
NULL
Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.
The Registry Key HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL
Server\<Instance Name>\SETUP\SQLPATH is ok. There is the correct path for
the SQL Server Binary
There is no Path with "-S" involved in the operations.
Any suggestion is very appreciated.
Regards
Paolo TavernaI'd add a report file:
exec master..xp_sqlmaint '-D pubs -WriteHistory -Rpt "C:\a.txt" -CkDB -CkAl -CkCat -RebldIdx 10'
(Change database name)
You can now check this report file for error messages. Note that xp_sqlmaint is deprecated in
2005...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paolo Taverna" <nospam@.nospam.spm> wrote in message news:%23OgxjZ9MGHA.2884@.TK2MSFTNGP12.phx.gbl...
> Hello
> I have a problem with the SQL Server 2005
> This is the Version i am using:
> Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37
> Copyright (c) 1988-2005 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> On the Server in the SQL Management Studio in a Query Window i execute the command:
> exec master..xp_sqlmaint '-D kunde -WriteHistory -CkDB -CkAl -CkCat -RebldIdx 10'
> this is the output i get.
> output
> ----
> NULL
> Microsoft (R) SQLMaint Utility (Unicode), Version 9.00.1399.06
> Copyright (c) Microsoft Corporation.
> NULL
> NULL
> Msg 22029, Level 16, State 1, Line 0
> sqlmaint.exe failed.
>
> The Registry Key HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\<Instance
> Name>\SETUP\SQLPATH is ok. There is the correct path for the SQL Server Binary
> There is no Path with "-S" involved in the operations.
> Any suggestion is very appreciated.
> Regards
> Paolo Taverna
>|||Hi Tibor
I executed xp_sqlmaint with the Parameter -Rpt like your sample. But the
Report File will not be generated. The remains the same Error.
Regards
Paolo Taverna
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag news:uZdSmi9MGHA.2124@.TK2MSFTNGP14.phx.gbl...
> I'd add a report file:
> exec master..xp_sqlmaint '-D pubs -WriteHistory -Rpt
> "C:\a.txt" -CkDB -CkAl -CkCat -RebldIdx 10'
> (Change database name)
> You can now check this report file for error messages. Note that
> xp_sqlmaint is deprecated in 2005...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paolo Taverna" <nospam@.nospam.spm> wrote in message
> news:%23OgxjZ9MGHA.2884@.TK2MSFTNGP12.phx.gbl...
>> Hello
>> I have a problem with the SQL Server 2005
>> This is the Version i am using:
>> Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37
>> Copyright (c) 1988-2005 Microsoft Corporation
>> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>> On the Server in the SQL Management Studio in a Query Window i execute
>> the command:
>> exec master..xp_sqlmaint '-D
>> kunde -WriteHistory -CkDB -CkAl -CkCat -RebldIdx 10'
>> this is the output i get.
>> output
>> ----
>> NULL
>> Microsoft (R) SQLMaint Utility (Unicode), Version 9.00.1399.06
>> Copyright (c) Microsoft Corporation.
>> NULL
>> NULL
>> Msg 22029, Level 16, State 1, Line 0
>> sqlmaint.exe failed.
>>
>> The Registry Key HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL
>> Server\<Instance Name>\SETUP\SQLPATH is ok. There is the correct path for
>> the SQL Server Binary
>> There is no Path with "-S" involved in the operations.
>> Any suggestion is very appreciated.
>> Regards
>> Paolo Taverna
>|||Hello
Don't mind about this thread. I replaced SQLMaint with a SSIS Package for
the Database Consistency and Index Rebuild. This works fine
Regards
Paolo Taverna
"Paolo Taverna" <nospam@.nospam.spm> schrieb im Newsbeitrag
news:%23OgxjZ9MGHA.2884@.TK2MSFTNGP12.phx.gbl...
> Hello
> I have a problem with the SQL Server 2005
> This is the Version i am using:
> Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37
> Copyright (c) 1988-2005 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> On the Server in the SQL Management Studio in a Query Window i execute the
> command:
> exec master..xp_sqlmaint '-D
> kunde -WriteHistory -CkDB -CkAl -CkCat -RebldIdx 10'
> this is the output i get.
> output
> ----
> NULL
> Microsoft (R) SQLMaint Utility (Unicode), Version 9.00.1399.06
> Copyright (c) Microsoft Corporation.
> NULL
> NULL
> Msg 22029, Level 16, State 1, Line 0
> sqlmaint.exe failed.
>
> The Registry Key HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL
> Server\<Instance Name>\SETUP\SQLPATH is ok. There is the correct path for
> the SQL Server Binary
> There is no Path with "-S" involved in the operations.
> Any suggestion is very appreciated.
> Regards
> Paolo Taverna
>