Accent-insensitive HELP.

Hello,
I need to change for an old db (SQL 2K) the property Accent-sensitive to Accent-insensitive and I don't know how .
If someone has a solution I needs some help please.
Thank you.Example: on a database named Products with the language French

ALTER DATABASE Products

COLLATE French_CI_AI

the CI_AI tells it to be Case Insensitive and Accent Insensitive|||Originally posted by Memnoch1207
Example: on a database named Products with the language French

ALTER DATABASE Products

COLLATE French_CI_AI

the CI_AI tells it to be Case Insensitive and Accent Insensitive

I try but doesn't work .
The script : ALTER DATABASE Products COLLATE French_CI_AI
return : The command(s) completed successfully.

but my select with : WHERE id = 'abcd' and WHERE id = 'abcde' is different .

?!|||Changed default database collation only.
You must alter all tables in you database.

A,Change collation of table columns by EM.

B,Faster would be
1.Generate script for all database by EM to text file without Generate drop existing option.
2.Open this file in notepad
3.Replace collation strings French_CI to French_CS (use your collation)
4.Copy create database part to QA and change database name and run
5.Switch to new database
5.Copy create tables part to QA and run
6.Use DTS wizard to copy data from your old database
7.Copy all remaining code to QA and run
8.Switch your databases by sp_renamedb (old->bak,new->old)

Note that server can use different collation from database. TempDb uses collation of model.