I know this is an old post, but it helped me to generate the following script that works against a SQL 2000 linked server (Update DBServerName, DBName, and TableName appropriately):

SELECT SC.name FROM DBServerName.DBName.dbo.sysobjects SO

JOIN DBServerName.DBName.dbo.syscolumns SC ON SO.id = SC.id

WHERE SO.Name = 'TableName'

AND SO.Type = 'U'

ORDER BY SC.Name

Thanks!

Matt