Collation Issues Handling

--FINDING COLLATION
--server level collation
select SERVERPROPERTY ('collation')
--DB level collation
select convert(sysname,DatabasePropertyEx(db_name(),'Collation'))
--Table level collation
select name, collation from syscolumns where [id]=object_id('Dim_ItemType')

--CHANGING COLLATION TABLE LEVEL
Alter table Dim_ItemType alter column ItemTypeName varchar(200) COLLATE Latin1_General_CI_AS NULL
--CHANGING COLLATION DB LEVEL
Alter database testNorwegian collate Danish_Norwegian_CI_AI