SQL Server 2000<BR><BR>I need to change the collation for a database from case senstitive to case insensitive. <BR><BR><pre class="ip-ubbcode-code-pre">ALTER DATABASE ...

We have a SQL Server in Azure where the server collation is SQL_Latin1_General_CP1_CI_AS and the Database collation is in Finnish_Swedish_CI_AS and when running SQLServerDatabaseMetaData.getIndexInfo ...

For "azurerm_mssql_database" "sqldb". If the collation is the same but case changes (say from proper to all caps) it wants to replace the the db which causes data loss. Can we make it to not be case ...