with what program do i change collate ?

I use visual studio and sql2008 express , and the only way i know is to click right click on the database in the server explorer , click on the right mouse button , and then on the new query
and then tryping alter database [database name] collate unf8
or something like that tried so many verisions of this , with collection before collate , with name after it
i just dont know anymore

is there some guide step by step to how to change the collate ? and with what program ?
cous i just dont succes

 

Hi,
You use a SQL command on your end fromSQL Server while connected to your remote database.
Here's a nice article that lists the collation for Hebrew.
http://www.serverintellect.com/support/sqlserver/change-database-collation.aspx
Shalom,
Mark



Technical Evangelist for DiscountASP.NET
http://www.iis7test.com/webcasts/
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

 

why THANKS on that .. solved my problem..
took me few hours but ok

until i downloaded SSMS and installed everything AND needed to delete everything first
and then the changing collate , and then until i understood that the old tables that i created still used the old collate and not the database default

but finally , i did it
thanks everyone

 

Good job


Technical Evangelist for DiscountASP.NET
http://www.iis7test.com/webcasts/
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx