Change database collation

--script to change database collation - James Agnini
--
--Replace with the database name
--Replace with the collation, eg SQL_Latin1_General_CP1_CI_AS
--
--After running this script, run the script to rebuild all indexes
ALTER DATABASE COLLATE

PlatformNotSupportedException Pocket PC

PlatformNotSupportedException when connecting from Pocket PC to a SQL Server Database.
>> If i try to connect to SQL Server with default collation
>> (i.e. SQL_Latin1_General_CP1_Cl_AS) then SqlClient is working fine and everything is fine.
>> Arif