There wasn't mindless violence at every game when you were allowed to drink. Just enough games to make it unworkable.
Sadly, I just don't think that Scottish drinking habits have changed sufficiently for it to work, although the all-seated stadiums might have some positive impact. To be honest, though, I'd rather have terracing and a dry stadium than seats with a pint at half-time.