Function CollationPropertyFromId required upgrade to CollationProperty:

Microsoft SQL Server 2000:

CollationPropertyFromId ( <collation_id>, 'sqlcharset')

Microsoft SQL Server 2008:

CollationProperty ( <collation_name>, 'sqlcharset')

Example:

Microsoft SQL Server 2000:

SELECT CollationPropertyFromID(col.collationid, 'sqlcharset')) FROM syscolumns col 

Microsoft SQL Server 2008:

SELECT CollationProperty(col.collation_name, 'sqlcharset')) FROM sys.columns col