Hi Chris,

Something like this:

USE [YourDatabase]

GO

;WITH DataProp as (SELECT pd.*
  FROM cmsPropertyData as pd
  JOIN cmsPropertyType as pt ON pt.Id = pd.propertytypeid AND pt.Alias = 'umbracoMemberApproved'
  WHERE contentNodeId = ( SELECT Id
  FROM umbracoNode
  WHERE text LIKE '%your member name%' ))
  UPDATE DataProp SET dataInt = 0

The part dataInt = 0 sets the property Is Approved to false, if you want to approve the member, set this to 1.

I now do a search on text for getting the right Member, you should be able to change this and pass the id of the member if you have this at your end:

WHERE Id = YourId

Hope this helps!

/Michaël