Apparantly there's some chemical in it (good for you I think) that makes some people's wee smell.
If yours smells, that's good because it means you have processed it. If it doesn't smell, it means you don't have the gene to process this chemical (I don't think I have it).
Fascinating. Can't remember the name of the chemical though. Perhaps run a search on "asparagus nutrition"?