index was out of range. Must be non-negative and less than the size of the collection.
-
observed below error in sqlserver2012 .
index was out of range. Must be non-negative and less than the size of the collection .
any suggestions to fix this .
-
That's a .Net error. What were you doing when you got it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Delete the plan using query-
SELECT
s.name AS [Name],
s.id AS [ID]
FROM
msdb.dbo.sysmaintplan_plans AS s
EXECUTE msdb.dbo.sp_maintplan_delete_plan @plan_id=N'{maintenance plan}'
GO
-
knk.dhyani (10/13/2016)
Delete the plan using query-SELECT
s.name AS [Name],
s.id AS [ID]
FROM
msdb.dbo.sysmaintplan_plans AS s
EXECUTE msdb.dbo.sp_maintplan_delete_plan @plan_id=N'{aqui vai o ID da query do maintenance plan}'
GO
Almost a two year old thread, and where do you get this solution to the original plan, thin air?
-
faced this yesterday.. came to this thread.. later found solution and shared.. hope this helps someone ahead 🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply