>That is exactly what I'm looking for. sys.sql_modules has the complete view definition even to the renamed fields. Thanks a bunch! Now I just need to work out the permission issues since the users won't have sa rights, but perhaps I can give the app role permission.
>

You're welcome.