Thanks, see my reply to Sergey.

Gary

>>Thanks for the reply. What I really need is the SQL select that makes up the view. I get that now from syscomments.
>>
>>Gary
>
>Check INFORMATION_SCHEMA.Views for View definition.
>
>See http://www.databasejournal.com/features/mssql/article.php/1460131
>
>>
>>>>Hi all,
>>>>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.
>>>>
>>>>Gary
>>>
>>>Did you mean in this forum Re: How do I find out if the column allows nulls? Thread #1043112 Message #1043117 ?