Solved

Creating a second instance

Posted on 2006-11-21
15
964 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to share SSIS Package? 6 37
SQL Update trigger 5 18
MS SQL + Insert Into Table - If Doesnt Exist 9 35
performance query 4 24
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

810 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