Ispirer Website
Ispirer Capabilities - Microsoft SQL Server Migration
Free Trial
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:
| Microsoft SQL Server 2000 (syscomments) | Microsoft SQL Server 2008 (sys.default_constraints) |
|---|---|
| id | object_id |
| text | definition |