>>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.
Can you script out CREATE TABLE of your table and post it here?