System table – syscomments

Compatability view should be upgraded to catalog view.

Microsoft SQL Server 2000:

 SELECT text FROM syscomments WHERE id = syscolumns.cdefault AND colid = 1

Microsoft SQL Server 2008:

 SELECT definition FROM sys.default_constraints WHERE object_id = sys.columns.default_object_id 

Column conversion: