The error message
Msg 448, Level 16, State 3, Line 14
Invalid collation ‘%.*ls’.
is a run time error message and may be generated at all versions of SQL Server. The reason for this error is use of unknown collation in a command. To remove the error specified collation name may be corrected first. Collations control the physical storage of character strings in SQL Server. Separate collations can be specified down to the column level in a table, and each column can be assigned different collations. To get list of available collations in SQL Server use following script
USE DBNamehere GO SELECT * FROM ::fn_helpcollations() GO
In case of SQL Server 2005 and onwards full colons may be removed from prefix of functions. Syntax for list of all collations in SQL Server 2005 and onwards will be
USE DBNamehere GO SELECT * FROM fn_helpcollations() GO