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.