all,
i'm trying to configure the search service for WSS 3.0 and i keep
getting this, Rebuild the database with the Latin1_General_CI_AS_KS_WS
collation

I have googled it and they all say uninstall and reinstall SQL (2000)
but if i do that wouldn't i lose all the date (some intranets have been
created already and don't want to lose them)

thx

You shouldn't have to reinstall SQL Server. You can use an ALTER DATABASE
on that DB. However, you'll have to go through each and every
char/nchar/varchar/nvarchar column of every table and alter it, too.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


[quoted text, click to view]
all,
i'm trying to configure the search service for WSS 3.0 and i keep
getting this, Rebuild the database with the Latin1_General_CI_AS_KS_WS
collation

I have googled it and they all say uninstall and reinstall SQL (2000)
but if i do that wouldn't i lose all the date (some intranets have been
created already and don't want to lose them)

thx
monica