Your final solution isn't the most efficient way to concatenate the strings. The STUFF function combined with FOR XML PATH would be the best solution. It would look...

Steve is right...you don't want to just unilaterally delete objects when you're not sure of their function.

We've started renaming objects to be deleted with the prefix "del_", and...

We found a solution.

It turns out these are orphaned aliases. The users to which they belonged were dropped, but the aliases remained behind. We got rid...

I figured there was a forehead slap and a "Doh!" in my near future.

I would never in a million years have thought to preface the index name with the table name, but that worked. Thanks!