>>When I run SQLCOLUMNS against SQL2000 I am getitng a column "column_def" that stores default values of columns defaults if they were specified. Same column from same statement against same table but from SQL2005 does not show default values. Any idea why?
>>
>>Thanks
>
>I have no problems, both 2000 and 2005 returns correct values.
Strange, from SQL 2005 that column has NULL values for all columns while I do have two columns with the default values. Can you show your SQL CREATE statement for that table?

Thanks