Solved

Creating a second instance

Posted on 2006-11-21
15
973 Views
Last Modified: 2008-01-09
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
0
Comment
Question by:crishna1
  • 6
  • 5
  • 2
  • +1
15 Comments
 
LVL 12

Expert Comment

by:Einstine98
ID: 17991764
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
 

Author Comment

by:crishna1
ID: 17991843
sorry if my question is not clear, i need to know how to create a second instance of sql server and its implications.
0
 
LVL 29

Assisted Solution

by:QPR
QPR earned 200 total points
ID: 17992057
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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 29

Expert Comment

by:QPR
ID: 17992082
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
 

Author Comment

by:crishna1
ID: 17992145
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
 

Author Comment

by:crishna1
ID: 17992152
may be i have something in the back ground that i am unable to see, let me log off and login and try.
0
 
LVL 29

Expert Comment

by:QPR
ID: 17992160
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
 

Author Comment

by:crishna1
ID: 17992730
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
 
LVL 12

Expert Comment

by:Einstine98
ID: 17992748
yeah, a reboot should do... ;)
0
 

Author Comment

by:crishna1
ID: 17992773
catchup Mr.Einstine...;-)
0
 
LVL 29

Expert Comment

by:QPR
ID: 17992793
I did this same thing just yesterday!
Select from the bottom drop down....

dictionary order, case-insensitive for use with 1252 character set
0
 

Author Comment

by:crishna1
ID: 17992810
i guess that will give me SQL_Latin1_General_CP1_CI_AS , correct?
0
 
LVL 28

Accepted Solution

by:
imran_fast earned 300 total points
ID: 17995446
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
 
LVL 29

Expert Comment

by:QPR
ID: 17998391
Yes
dictionary order, case-insensitive for use with 1252 character set gives SQL_Latin1_General_CP1_CI_AS
0
 
LVL 28

Expert Comment

by:imran_fast
ID: 18026024
Thanks this question made me Genius in this section.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question