Hi Experts,
I have a database on which i want to change collations, i m not able set the all collations of sql server.
SELECT Name FROM ::fn_helpcollations()
i used this sql for populating drop down list in the client.
when i try to change some collations i m getting following error:
"Invalid object name Information_Schema.Columns "
Invalid object " SELECT Column_Name, Is_Nullable, Data_Type, Character_Maximum_Length, Collation_Name FROM Information_Schema.Columns WHERE table_catalog = 'renameindex' AND Table_Name = 'AccessObject'
I want find the supported list of collations for particular database.
I used char, varchar, text, nchar, nvarchar, and ntext data data type columns in the table.