• SELECT SysProperties.Value

    FROMSysProperties

    INNER JOIN SysColumns ON SysProperties.id = SysColumns.id AND

    SysColumns.colid = SysProperties.smallid

    WHERE (SysProperties.name = 'MS_Description') AND

    (Object_name(Syscolumns.id) = <TableName>) AND

    (SysColumns.Name = <Columnname>)