Written by:R Teachout
12/4/2006 3:11 AM

I found this is ONE newsgroup...

A workaround by means of system sp's.

I used SQL Profiler.

Verify that the folder is missing:
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'

Add the folder if missing:
exec sp_dts_addfolder '00000000-0000-0000-0000-000000000000','Maintenance Plans','08AA12D5-8F98-4DAB-A4FC-980B150A5DC8'

Voila, then it's there..

TrackbackPrint

Location: BlogsRamblings, Scriptlets, and more!MSSQL Scriptlets

Your name:
Title:
Comment:
Security Code Enter the code shown above in the box below
Add Comment   Cancel