Cannot find the function xp_sqlmaint in the library C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlmaint.exe. Reason: 127(The specified procedure could not be found.). [SQLSTATE 42000] (Error 0). The step failed.
The extended store procedure xp_sqlmaint is being registered to a wrong dll/libery.
1) Open SSMS or Enterprise Manager
2)Connect to the Server having problem
3) Navigate toMaster Database
4) Navigate to Extended Store Procedure or Programability | Extended Store Procedure in SSMS
5) Right Click on xp_sqlmaint and Select Property
6) Under General Tab, change dll to xpstar.dll
7 Click OK to commit the changes.
xp_sqlmaint is a native extended store procedure comes with the Microsoft SQL Server.
For SQL Server 2000, it is pointing to xptar.dll
For SQL Server 2005, it is pointing to xpstar90.dll
