I am getting the following error on SQL 2005 Sp2 on the query below

SELECT @Collation = CONVERT(SYSNAME,DatabasePropertyEx('master','Collation'))

Msg 137, Level 15, State 1, Line 1

Must declare the scalar variable "@Collation".