Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update Collation field in syscolumns table

Status
Not open for further replies.

MrJRW

IS-IT--Management
Feb 6, 2002
47
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top