I've found a small change should eliminate repeating rows:

DECLARE @TableName Varchar(100)

SET @TableName = 'ASection'

SELECT

 SC.name,

 SP.value

FROM syscolumns SC LEFT OUTER JOIN sysproperties SP ON

SP.id = SC.id

and SC.colid = SP.smallid

WHERE SC.id = object_id(@TableName)