SQL Server: Only Database and Object Collation Change
Well this gonna be a boring and very lengthy blog. But I have prepared it after researching with the geeks' docs. I finally made my database with another collation. Previously I thoght that only unique and primary key will need to be recreated but the thing is nonclustered and non unique index also need to be changed. Any way go through my steps and suggests if I missed any thing. At the end I have given all the sources I used. Summary: The existing Database connection can be changed using the ALTER Database command provided in SQL Server. To change the collation settings Restrict the Database access to Single User Mode Change the Database collation using the following syntax. ALTER DATABASE dbname COLLATE [Replace Actual Collation] GO This will only change the collation of the Database and not the collation of the Database objects (Tables) if any exists already. We need to explicitly change the collation of the character (VARCHAR / NVARCHA...