Viewing 3 posts - 16 through 18 (of 18 total)
Dear damian:
The sript you provided sounds like incomplete?
Would you please help to check it, thanks!
February 11, 2009 at 12:09 am
Thanks damain~:)
With your script I see the objects belong to their filegroups.
But,though there is NULL in the filegroup, I still cann't remove it, and also says:
Msg 5042, Level 16, State...
February 9, 2009 at 5:39 pm
I also encountered this problem, and resolved as following:
USE [msdb]
declare @job_name varchar(100)
set @job_name = N'SystemDB-MaintenancePlan.Subplan_1'
delete sysmaintplan_log
FROM sysmaintplan_subplans AS subplans INNER JOIN
sysjobs_view AS syjobs ON subplans.job_id = syjobs.job_id INNER JOIN
sysmaintplan_log ON...
January 31, 2009 at 11:47 pm
Viewing 3 posts - 16 through 18 (of 18 total)