Programming Stuff

Fix SQL Collation Error

I tried to create a Trigger that update the table in another Database and I got this error

I search for a solution and I found many partially solution, like especify the collacation on the select… so what about update, delete and insert operations???  I really was looking for something at the database level. I found this:

And I got another error:

And I couldn’t lock the database, many user and such as such as…

I got lucky and found this Script: (just make sure of ONLY change [YOUR_DATABASE])

I got a result like this (other scripts)…

After I execute this scripts and I could make the trigger work and avoid  future headache.

Source: http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/1bbb2931-9f01-4150-89a6-a697fe804d72