Need both Case Sensitive and Case Insensitive DBs on SQL Server 2005

Help!!!! Our ERP software requires that we installed SQL Server with Case Sensitive, now I am trying to install a VMWare database and it has to be Case insensitive!  Getting an error that VMware does not support a CS database.  Is there anyway I can accomplish this.  I do not want to buy another SQL server when there is plenty of space on our existing server.
reboot5Asked:
Who is Participating?
 
joeviCommented:
Given your requirements I'm not sure you have much of an option. If the production server resources are adequate (Processors, Memory & Disk space) enough to support two instances - you'll be fine.

Note: I'm not a VMWare expert so you may want to check with VMware (or Experts-Exchange Expert) on using Express.
Note2: I feel your pain on Case Sensitive SQL Server configurations. I've yet to see a good reason for it's use in 'typical' database solutions.
0
 
EvilPostItCommented:
It is dependant upon the temprorary table usage of your database. You can set any database to be either case sentitive or case insensitive. But the instane itself needs to be one or the other.

If both tables use temporary then unfortunatly you will have to put these databases in seperate instances.
0
 
joeviCommented:
How about using SQL Server Expre$$ for the VMWare instance/database?
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.

 
reboot5Author Commented:
I thought about using SQL Express, but I don't want to run out of room right away..
0
 
reboot5Author Commented:
So if I create a new instance, when this server is a produciton server, if will not intterupt the other databse users?
0
 
reboot5Author Commented:
Thanks, it is nce to get others point of views and the response has been quick.
0
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.

All Courses

From novice to tech pro — start learning today.