Same problem with my 2004 Spider. Tried the hammer technique advocated by some....a couple of mothes ago this worked and the roof kept working afterwards. Now when I release the roof latches and press the console button..................nothing, nada, zip !! Tried the hammer thing again but to no avail. I can raise and lower it manually, using the buttons behind the driver's seat but it's a real effort (and doesn't look nearly as cool!) I'm no mechanic so am a little reluctant to dismantle the motor (in the rear cubbyhole, behing the carpet) Also very reluctant to spend £300-400 on a replacement motor!!
I've read that the cause could be:
a) stripped plastic/nylon cog/wheel inside the motor - this apparently can be turned thru 90 degrees and refitted.
b) low hydralic fluid level in the small 'tank' also somewhere behind the seats in the cubbyhole/locker
c) microswitch failure (????)
or d) just cr*p Alfa electrics.............(I also get intermittant 'code' problems that prevent me from starting the engine. Periodically, the little Alfa gremlins decide to go back to work and then they go on strike again....who knows?!)
Still....I was warned that my little mid-life-crisis-weekend-toy-posemobile-tempremental-female-sports-car-thingy would require even deeper pockets than needed to keep the average WAG in shoes...
Oh the joys of Alfa ownership....!