DB Maintenance Plans

• Taj

  Mr or Mrs. 500

  Points: 596

  More actions

  October 27, 2004 at 1:40 pm

  #86795

  OK guys...who wants to take a shot at this.....simple problem but with no explanation..

  I am trying to run sp_help_maintenance_plan procedure from query analyzer and sql server refuses to recognize it. Its one of sql server built in SP's.

  Is it one more boo boo of Microsoft or its something I am doing wrong.

  Can somebody run and let me know.....if it get recognized on their end.

  Thanks

  
  Tajammal Butt

• john-132685

  SSCertifiable

  Points: 6134

  More actions

  October 27, 2004 at 2:05 pm

  #528213

  sp_% procs are available anywhere only if they exist in the master db.  That proc is in the MSDB database so you'll need to qualify it:

  exec msdb..sp_help_maintenance_plan

• Taj

  Mr or Mrs. 500

  Points: 596

  More actions

  October 27, 2004 at 2:10 pm

  #528217

  Thanks..you were right at mark....BOL should say something about this.

  Thanks once again

  
  Tajammal Butt