Written by:R Teachout12/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..
1 comment(s) so far...
sqlWell, great post, thanks. I love to read sql posts and articles, thanks for sharing.# sql
sql
Well, great post, thanks. I love to read sql posts and articles, thanks for sharing.# sql
