I am facing this error when i am programatically delete record from sharepoint list. column is lookup column in another list and i have set cascade delete option enable in list. I am facing below error. Can any one give me solution to delete record programatically

Maximum number of items to delete has been reached. Please contact the Site Collection Administrator.

2 Answers 2


try this

Open SharePoint 2010 Management Shell and execute the following:

$site = spsite "URL"

Now we have to set the maximum number of items that can be checked in a Cascade or Restrict delete operation.

It is applicable to lists which have referential integrity enabled in them.

$site.WebApplication.CascadeDeleteMaximumItemLimit = [number of items]

By default the [number of items] = 1000

Here is a source post;

Hope it helps,


  • please summarize the gist of the solution in the post. Links can go bad.
    – teylyn
    May 16, 2013 at 10:42

Try to change the CascadeDeleteMaximumItemLimit property. This controls the duration of a short-term Web site lock that is taken to perform referential integrity delete operations.

You can try this in powershell:

$site = spsite "http://[your site collection URL]"
$site.WebApplication.CascadeDeleteMaximumItemLimit = [# of items]

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.