>hi, how are you, I have the following problem I have an application with VFP9 and SQL Server 2005 when run on a PC with Windows XP runs fine but when I try to do it on a server running Windows 2003 Server collation gives me error generates modern_spanish_ci_As with latin1_ general I can do
You can change the collations of all the *char and text fields to be the same, preferably with something like
alter table mytable alter column field1 [column type here] collate database_default
Two troubles here:
1) one column at a time (which can take some time for large tables)
2) for columns involved in indexes or constraints and a few other cases, you can't do this without either re-creating the table or dropping all those constraints and indexes, then re-creating them.