When I execute

exec sp_executesql N'exec [msdb].[dbo].[sp_dts_getfolder] @P1, @P2',N'@P1
nvarchar(17),@P2 uniqueidentifier',N'Maintenance
Plans','00000000-0000-0000-0000-000000000000'

I get columns labeled folderid, foldername, parentfolderid, and foldername
with no data returned. What does that mean?

When I execute

exec sp_dts_addfolder '00000000-0000-0000-0000-000000000000','Maintenance
Plans','08AA12D5-8F98-4DAB-A4FC-980B150A5DC8'

I get the following error message:

Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_dts_addfolder'.

What does that mean?

"Ekrem Önsoy" wrote:

> Hi Dave,
>
>
> I don't know about this issue but I could give you a link in which a guy
> says he found a solution to this problem.
> http://www.developmentnow.com/g/118_...nce-Plans-.htm
>
> Besides, Microsoft has a fix for "Exception has been thrown by the target of
> an invocation. (mscorlib)" However I do not think it's about lack of
> Maintenance Plans folder:
> http://support.microsoft.com/kb/328560
>
>
> --
> Ekrem Önsoy
>
>
> "Dave Landers" <Dave Landers@discussions.microsoft.com> wrote in message
> news:7198BBE3-9BCC-482D-9617-A7D9506882E5@microsoft.com...
> >I get the following error message when I try to create a new maintenance
> >plan
> > on a new SQL Server 2005 installation. Any ideas?
> >
> > TITLE: Microsoft SQL Server Management Studio
> > ------------------------------
> >
> > Exception has been thrown by the target of an invocation. (mscorlib)
> >
> > ------------------------------
> > ADDITIONAL INFORMATION:
> >
> > Cannot find folder "\Maintenance Plans".
> >
> >
> > ------------------------------
> >
> > Cannot find folder "\Maintenance Plans".
> >
> >
> > ------------------------------
> > BUTTONS:
> >
> > OK
> > ------------------------------
> >
>
>