Hi all,
I've been wrestling with hundreds of sign ups by bots every day, but didn't want to use Captcha (as it discourages customers), so I figured I'd write a stored procedure to run every 15 minutes to delete these accounts.
Unfortunately, these accounts do not have any addresses in the Address table, so I'm trying to figure out where the phantom customer addresses are stored - that way I can delete any customer with an address containing the bogus phone #s '123456'.
I considered deleting all customers with no Shipping/Billing address, but some could be legitimate and hadn't added an address yet (where in the heck is the initial address stored?)
