Look at the syscolumns table in your database, there's a collation column so you can easily test this to see if any columns aren't the default collation. (Use OBJECT_NAME(id) to see which table the fields belong to.) Something like this should get you started
SELECT OBJECT_NAME(id) AS ObjName, [name], [collation]
WHERE [collation] IS NOT NULL
Alternatively you can use EM to script all the tables (All Tasks > Generate SQL Scripts) and examine the script by eye.