Mnn, if you assign the users appropriate limited permissions

Won't they just use the same SSMS interface, just with less options?

They don't see everything a sysadmin would see

Beyond that, either write your own GUI or SMO/Power Shell (which I think it's only in SQL 2008)?