Typical Collation Bugs that hurt portability.

tempid - TempID

englishalpha - EnglishAlpha

Master.sys.SysColumns (should be) master.sys.columns

(I'd prefer) master.sys.columns (SQL2005 view for portability with SQL 2000)

A lot of posted SQL code falls...