Post reply

Change collation in SQL Serrver 2008 database.

  • November 30, 2010 at 3:10 am

    #388332

    Hi,

    I have a database on SQL Server 2008 its default collation is SQL_Latin1_General_CP1_CI_AS now I have changed the collation to SQL_Latin1_General_CP1_CS_AS. But after changing the collation only object's name in this database and columns name have become case sensitive. I want all informations in columns

    should be case sensitive. What else I can do?

    Please help.

  • December 1, 2010 at 7:10 am

    #1257332

    If I understand what you are asking... I believe you have to copy the data out of the table(s) and then re-import the data for the change in collation to take effect on the data within the table.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply