MSSQL: The value of Default Constraint

You can find it in the syscomments system table:

SELECT C.[text]
  FROM sysobjects O 
  JOIN syscomments C 
    ON O.[id] = C.[id]
 WHERE O.[name] = 'DF_T_BUGS_SYS_DATE'

Related Posts:

• MSSQL 2000: Row Count Using sysindexes System Table
• MCP Hall of Fame
• MSSQL: Paul McBride on ISNULL vs. COALESCE
• MSSQL: Quest Software to compete Red-Gate
• SQL Server 2005 Product Line published
• Advanced MSSQL 2005: Partitioning, memory management, etc
• More MSSQL
• How to Use XMLHTTP from within T-SQL (sp_oacreate)
• T-SQL Tip: How to Use GETDATE() in User Defined Function
• T-SQL: Search Logic