Forum Replies Created

Viewing 3 posts - 16 through 18 (of 18 total)

  • RE: Remove a Filegroup

    Dear damian:

    The sript you provided sounds like incomplete?

    Would you please help to check it, thanks!

  • RE: Remove a Filegroup

    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...

  • RE: Drop failed for jobs

    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...

Viewing 3 posts - 16 through 18 (of 18 total)