Mass Update Active Directory

I'm trying to update about 8500 records in active directory and I'm getting the following error when I run my SQL query:

LDAPException: Sizelimit Exceeded (4) Sizelimit ExceededLDAPException: Matched DN: -- null
Here is my SQL query (with modified values):

UPDATE OU=Users,DC=example,DC=com SET telephoneNumber=NULL WHERE telephoneNumber='519-111-2222' subtreescope

I also changes the Max. Results value to 10000.

If I do a search for all users with that phone number I get 8344 entries returned, so I don't think there is anything wrong with the domain controllers settings. I even set MaxPageSize to 10000 and MaxResultSetSize to 1Mb on the domain controller and I still get the same error.

Any help would be greatly appreciated.

Try one of the following:

Increase MaxPageSize (http://support.microsoft.com/kb/315071) and
disable Enable Ldap Paged Result control from Preference|General (Last
check box)

or

Constraint update to less than 1000 using some attribute for e.g (and sn
like 'a%' or 'b%') and run update sql a few times.

UPDATE OU=Users,DC=example,DC=com SET telephoneNumber=NULL WHERE telephoneNumber='519-111-2222' and sn like 'a%' or 'b%' subtreescope;

Thanks, I will do it in increments.

How do I set the value of the attribute so that there is no value that appears in AD? If I do SET telephoneNumber = NULL, NULL appears as the phone number, if I do SET telephoneNumber = '', '' appears as the phone number.

Try Null in small letters - null - also no space after =

SET telephoneNumber=null

Thanks alot, it worked perfectly!