SELECT sysobjects.name,syscolumns.name
 FROM sysobjects INNER JOIN syscolumns ON sysobjects.id = syscolumns.id
 WHERE  syscolumns.name like '%member%'
 ORDER BY syscolumns.colorder