How to change the localtion of WSS_Content Database (sharepoint3.0)

Hi, i am using sharepoint 3.0 and default Embedded Version of SQL express.

Now I would like to change the directory of WSS Content and Search database

(instead of C drive)

When I was using WSS2, I changed it using OSQL command.

For WSS3.0 it is a little different.

Could you help me how to change database directory?

Thanks

That KB article should guide you, through it is for 2.0 > 3.0

http://support.microsoft.com/default.aspx/kb/925190

Jens K. Suessmeyer.

http://www.sqlserver2005.de

how to change in SQL 2005 and accept the bin caracter and the langage

Hello

I am newbies with SQL 2005

I want install Windows sharepoint services 3 in french on my SBS 2003 R2 SP2 also in frecnh langage and at the end of the install, a message say to me :

Bin caracter are not accepted in your configuration SQL

Langage is not correct (I have French_CS_AS)

Where is possible to change these parameters ?

I try to find but never find

Thank You in advance for your help

++

Michel

If you have the answer in French it's better for me but not neccessary !

You need to change your collation to French_BIN which means alter database and change collation you can do it in the database properties. You have to know that BIN(binary collation) is the fastest sort but it also require you to use case sensitive data including queries. Run a search for ALTER database, table and columns and binary sort in SQL Server BOL. Check out SQL Server collations below.

http://msdn2.microsoft.com/en-us/library/ms180175.aspx