I saw this post by Jamie Thomson and I couldn't help but play "name that tune". Specifically, I figured that it wouldn't be too difficult to do the same in powershell without having to worry about collations, double quoting issues, and the like. It turns out that I was wrong. I discovered a bug in SMO where if you try to retrieve the extended properties for an index that is a primary key, SMO fails to do so. I've logged a Connect item on it.