About Me

Colorado
Paul has 18 years experience with Microsoft SQL Server. He has worked in the roles of production DBA, database developer, database architect, applications developer, business intelligence and data warehouse developer, and instructor for students aspiring for MCDBA certification. He has performed numerous data migrations and supported large databases (3 Terabyte, 1+ billion rows) with high transactions. He is a member of PASS, blogs about lessons learned from a developer’s approach to SQL Server administration, and has been the president of the Boulder SQL Server Users’ Group from January 2009 to present. 517 Lafarge Ave. Louisville, CO 80027 7667 Dyer Road Louisville, CO 80027

Monday, August 17, 2015

Error when attempting to delete a maintenance plan in SQL 2005 using SSMS 2014.

Here is an error I received when attempting to delete a maintenance plan in a SQL 2005 instance using SSMS 2014.  



Exception has been thrown by the target of an invocation. (mscorlib)
Additional information:
Index was out of range.  Must be non-negative and less than the size of the collection.
Parameter name: index (mscorlib)


I was able to successfully delete the object by using SSMS 2005.