Hi Everyone,

I tried to change a table column from case sensitive to case insensitive

---ORIGINAL
Name VARCHAR(255) COLLATE Latin1_General_BIN NOT NULL ,

---NEW CHANGE
Name VARCHAR(255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL

but it told me that I can't change it because there is a replication setup
on this database and table.
what's the easiest way I can do?  do I have to disable replication then do
the change, and then go back re-enabled replication?


Thanks
      Jay

Find duplicates
Selecting when Dates in where clause
"If you want a lot of information, one has to use cursors."
How to get variable number of rows on one row.
date of the month