The judgment would still be in Santa Clara County. However, the judgment creditor might have located assets in Alameda County, such as a bank account, some real property, or even a horse. The only way to have the sheriff act is to obtain a writ of execution for the county in which it's believed an asset is located.