Good Afternoon
I altered the collation of a database to become case insensitive. (ALTER DATABASE X COLLATE SQL_Latin....)
This altering updated SOME of the values of syscolumns.collation
However, running an UPDATE script to change the remaining non-null column names to my new collate value resulted in a error:
"Column 'collation' cannon be modified because it is a computed column."
? - Any ideas how to change/update the collate value ?
Thanks
MrJRW
I altered the collation of a database to become case insensitive. (ALTER DATABASE X COLLATE SQL_Latin....)
This altering updated SOME of the values of syscolumns.collation
However, running an UPDATE script to change the remaining non-null column names to my new collate value resulted in a error:
"Column 'collation' cannon be modified because it is a computed column."
? - Any ideas how to change/update the collate value ?
Thanks
MrJRW