What T-SQL command can be run to find character set of a table or database in SQL Server?
edit: Server version: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)