score:0

Accepted answer

You can update the collation for the table. Here are the steps to do so:

  1. In SQL server management studio, right click on the database in question and choose properties.
  2. In the properties dialogue box, choose "Options" in the left pane
  3. In the right pane, the current collation will be listed against Collation label.
  4. Change to desired and apply.

PS: Ensure all components accessing the database are stopped while doing the above. Failing this will cause an error to pop-up.

Here is where I found this information (2nd to last thread): http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=77212


More questions

More questions with similar tag