Thanks for the reply. What I really need is the SQL select that makes up the view. I get that now from syscomments.

Gary

>>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 ?