|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
![]() |
|
|
LinkBack | Outils de la discussion |
|
|
#1 |
|
Messages: n/a
Hébergeur: |
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 ------------------------------ |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
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 > ------------------------------ > |
|
|
|
#3 |
|
Messages: n/a
Hébergeur: |
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 > > ------------------------------ > > > > |
|
![]() |
| Outils de la discussion | |
|
|