Coverting entire database from in-case sensitive to case sensitive?

[HDRip]

I have a database equaling 57MB in size and need to know if the entire database can be converted from in-case sensitive to just case sensitive without having to go into each table and run a script. Does anyone know if there is a quick way to do this (ie: either a script or an application?) without having to reinstall the server 7 or server 2000?

Thanks
HDRip

 

[tlbroadbent]

There is no "quick" database conversion. You can alter table columns and change collation but not databases. Check the articles at the following links for information about changing the collation of a database.

http://msdn.microsoft.com/library/en-us/architec/8_ar_da_819v.asp

http://msdn.microsoft.com/library/en-us/architec/8_ar_da_3zw3.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums. NOTE: Reference to the FAQ is not directed at any individual.