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
>

CHanging default listing port sQL 7.0

How do I change th e default port SQL server 7.0 listens
to. I need some urgent asisstanceOpen up the server network utility (found in the SQL Server folder of the
start menu) and then highlight TCP and choose properties.
Andrew J. Kelly
SQL Server MVP
"lyle" <anonymous@.discussions.microsoft.com> wrote in message
news:1962a01c44ceb$bb9c1350$a501280a@.phx
.gbl...
> How do I change th e default port SQL server 7.0 listens
> to. I need some urgent asisstance

Changing DataSource

HI,
I am having a problem and its very urgent,
i have made a report in test database it worked fine, now i wana run it on live database, i have changes its datasource and updated it as well, but agin its piking data from test database.
i cant understand why????
i have refreshed the report, logged in logged off , evry thing possible i have done but it is picking data from test database :(

can any one help me?i have made the TEST database offline now its show error message that TEST data base is offline......i could not understand why it is going for TEST database....when i have updated datasource with LIVE one....!!!

every where it is shown LIVE database but when i m goin to refresh it it goes for TEST :(

plzzzzzzzzzzzzzzz can any 1 help ???|||Problem resolved :)
it was my mistake i was not maping all tables one by one...!! was just maping database...!!!