>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.