Select and change collation of T-SQL tables and databases

I could have sworn I wrote a collation article a while ago. Anyway, here are some links:

• an article about getting and setting the collation for Transact SQL databases and tables:TSQL to change collation of database
• A list of available collations
• if you get a collation conflict error, you need to collate every join or where like in this example:select * from profile, userinfo
  where profile.custid collate database_default = userinfo.custid collate database_default