Sergey,
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.

Thanks again.

Gary

>>I've been using sysobjects and syscomments in SQL 2000 to get base table information on our views. I seem to dimly recall that in SQL 2005 this is discouraged in favor of using a system view or information_schema.???? or a sp_something or other. Does anyone have any info on this? Thanks.
>
>Hi Gary,
>
>In SQL 2005 info about views stored the following catalog views: sys.views, sys.columns, sys.sql_dependencies and sys.sql_modules. The last one stores the text of the CREATE VIEW statement.