Creating a second instance

Dear Experts,

I have sql server 2000 installed on a server with, SQL_Latin1_General_CP850_CI_AS.

Can i create another database instance with a different collation/sort-order CP1_CI_AS ?

If i can, How do i do it and what will be the impack on the server, how is the memory managed?

Please explain.

many thanks
crishna1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Einstine98Commented:
You can, when you careate your database in Ent. Manager choose the collation (right the bottom of the first form)... and thats it...

the problem would be when you use the temp db as it will have different collation to your db and then you need to do some coding to go around it.
0
crishna1Author Commented:
sorry if my question is not clear, i need to know how to create a second instance of sql server and its implications.
0
QPRCommented:
To create a second instance of sql on the same server you install a "named instance"
http://msdn2.microsoft.com/en-us/library/aa197928(SQL.80).aspx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

QPRCommented:
During the install you pick "custom" for the install step.
Here you can choose your collation.
They should live happily side by side until you do something like a distributed query like

select * from db.owner.table A
inner join server2.db.owner.table B
     on A.fieldname = B.fieldname
     
If A.fieldname and B.fieldname are text fields then you may run into problems with different collations.
But as Einstine98 said you can specify handling collation in your code.
If you don't intend server1 to talk to server2 then ignore all of the above
     
0
crishna1Author Commented:
QPR, Thank you very much for your responce.

wheni run the autorun.exe , it get a message that " another instance of setup is already running".

What do i do? I tried it by stopping the existing sql server sercie, but still ge the same error.

Please advice.

Thanks
0
crishna1Author Commented:
may be i have something in the back ground that i am unable to see, let me log off and login and try.
0
QPRCommented:
Interesting. It is telling you the install program is already running, not SQL.
Have you done a reboot since the default (first) install?

Either way I would reboot if I were you.
0
crishna1Author Commented:
Bingo! reboot worked.

it seems like working now, one last question, what do i select from the given collations during installations to get the following:
SQL_Latin1_General_CP1_CI_AS

is this the deafult ?
0
Einstine98Commented:
yeah, a reboot should do... ;)
0
crishna1Author Commented:
catchup Mr.Einstine...;-)
0
QPRCommented:
I did this same thing just yesterday!
Select from the bottom drop down....

dictionary order, case-insensitive for use with 1252 character set
0
crishna1Author Commented:
i guess that will give me SQL_Latin1_General_CP1_CI_AS , correct?
0
imran_fastCommented:
hi,

Change the collation of your database before creating any object in it
using

ALTER DATABASE MyDatabase COLLATE French_CI_AS

or
check this
http://support.microsoft.com/kb/325335
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
QPRCommented:
Yes
dictionary order, case-insensitive for use with 1252 character set gives SQL_Latin1_General_CP1_CI_AS
0
imran_fastCommented:
Thanks this question made me Genius in this section.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.