sqlmain.exe failed (SQLSTATE 42000) (Error 22029).

• Minaz Amin

  SSChampion

  Points: 11052

  More actions

  November 30, 2007 at 1:05 am

  #755831

  [SQLSTATE 42000] (Error 22029) is a generic error

  Please try to run this command and you will find the exact error message

  select * from msdb.dbo.sysdbmaintplan_history

  post that error message !!

  "More Green More Oxygen !! Plant a tree today"

• official.nitin

  SSC Rookie

  Points: 43

  More actions

  February 11, 2009 at 7:26 am

  #942125

  Please check this link, it resolved my issue.

  http://support.microsoft.com/default.aspx?scid=kb;en-us;Q303292