>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
