I can't even remember seeing an option to install MS SQL as case-insensitve for at least a couple of versions. When it was there, it was still tied to Sybase (i.e. v6), where you simply selected a dataset that fit your needs, and selected your case sensitivity once and for all at that time.
What version of SQL are you using? Rick On 12/5/06, CONDREA, Daniel <[EMAIL PROTECTED]> wrote:
** > Is MSSQL really case insensitive? It depends how it installed. Here is case sensitive ------------------------------ *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Axton *Sent:* 05 December 2006 17:10 *To:* [email protected] *Subject:* Re: Database ** > Is MSSQL really case insensitive? Yes > We have several stored procedures in ORACLE. How flexible is MSSQL when it comes to stored procedures? The stored procedures are very capable, but the code does not transport between the two RMDBS systems you referenced. You will have to rewrite the sp's. > I have heard many say the Windows is not as stable as UNIX. How stable is MSSQL? My personal experience has been that, on MS, the more you install, the less stable the system becomes. In corp/institutional environments, this roughly translates to, the more groups you have involved in managing your servers, the less stable they are. In the shops where my group managed the servers from the wall out, windows was rock solid. In the shops where there was a storage group, an OS group, a security group, a hardware group, a network group, an hp group, an oracle group, and many other groups involved in the management of the system, the thing continually falls apart. Axton Grams On 12/5/06, David Yearsley <[EMAIL PROTECTED]> wrote: > > ** Our current environment has included a ORACLE database more than 6 > years. Our hardware is reaching the end of its life and because of Price and > the Case Sensitivity of ORACLE we are looking at possibly replacing ORACLE > with Microsoft SQL. > > As we investigate this change there are several questions I would like > to ask. > > Is MSSQL really case insensitive? > > > We have several stored procedures in ORACLE. How flexible is MSSQL when > it comes to stored procedures? > > > I have heard many say the Windows is not as stable as UNIX. How stable > is MSSQL? > > > Has anyone made the switch from ORACLE to MSSQL? If so, do you have any > advice? > > > Any information we are overlooking? > __20060125_______________________This posting was submitted with HTML in > it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ -- *****DISCLAIMER***** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania S.A. is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. *****END OF DISCLAIMER***** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
