Seeder question: In SQL Server 2000 I used to retrieve the source text for a computed column definition from syscolumns - however I am now using 2008 and I want to move to the newer system views - where do i now find the definition, as it doesn't seem to be in sys.sql_modules?
Try catalog view SYS.COMPUTED_COLUMNS.
declare @tableName Nvarchar(50)
set @tableName = 'dbo.SequenceControl' -- change this for your purposes
select @tableName as TableName,sc1.name as columnName, isnull(sc2.definition,'') as def
from sys.columns sc1
left join sys.computed_columns sc2
on sc2.[object_id] = sc1.[object_id] and sc2.[column_id] = sc1.[column_id]
where sc1.[object_ID] = object_id(@tableName)
order by sc1.column_id
