Changing SQL 2000 Server colation - urgent!

Hi,
I've installed the SQL 2000 Server with SQL_Latin1_General_CP1_CI_AS
collation.
I've restored databases from different server with Hebrew_CI_AS collation,
and there is a oproblem to see Hebrew characters in the databases.
Can i change the collation for entire server (preferably without reboot) in
order to see characters well in all DBs and how exactly can i do that?
Or i need to make the collation change for every DB separately, and how it
can be done?
Thanks,
BarakBarak Turovsky wrote:
> Hi,
> I've installed the SQL 2000 Server with SQL_Latin1_General_CP1_CI_AS
> collation.
> I've restored databases from different server with Hebrew_CI_AS
> collation, and there is a oproblem to see Hebrew characters in the
> databases.
> Can i change the collation for entire server (preferably without
> reboot) in order to see characters well in all DBs and how exactly
> can i do that?
> Or i need to make the collation change for every DB separately, and
> how it can be done?
See "How to transfer a database from one collation to another collation in
SQL Server"
http://support.microsoft.com/?kbid=325335#8
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Shalom,Barak
Try to use ALTER TABLE command with the option to change COLLATION.
Did you try to change these column to NVARCHAR datatype to see if you can
see the data?
Did you have your Server as 'Hebrew Enabled'?
You may encounter some problems when you try to JOIN the columns with
differnt collations.
"Barak Turovsky" <baraktur@.mail.ru> wrote in message
news:#1lWDgLEEHA.2576@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I've installed the SQL 2000 Server with SQL_Latin1_General_CP1_CI_AS
> collation.
> I've restored databases from different server with Hebrew_CI_AS collation,
> and there is a oproblem to see Hebrew characters in the databases.
> Can i change the collation for entire server (preferably without reboot)
in
> order to see characters well in all DBs and how exactly can i do that?
> Or i need to make the collation change for every DB separately, and how it
> can be done?
> Thanks,
> Barak
>