You can also change the collation sequence at the procedure level.
Case sensitivity doesn't seem to be maintained across linked servers between procedures and tables. We had it enabled at the table level and it maintained case sensitivity when the procedure was on the same server-it didn't maintain case sensitivity when the stored procedure/function was on a different server from the table. We implemented case-sensitivity within the stored procedure/function to work around that problem. The bottom line is you can make SQL Server case-sensitive at several levels. By default, our server is case-insensitive and we enable it as needed where needed. CRAIG J. CARTER _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen Sent: Wednesday, December 06, 2006 12:08 AM To: arslist@ARSLIST.ORG Subject: Re: Database ** You can select the case sensitivity by changing the collation. You can change the collation of the entire database or only of a certain table. See http://msdn2.microsoft.com/en-US/library/ms144250.aspx <http://msdn2.microsoft.com/en-US/library/ms144250.aspx> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=60020 <http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=60020&SiteID=1> &SiteID=1 -- Michiel On 12/5/06, Rick Cook <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: ** 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 < <mailto:[EMAIL PROTECTED]> [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:arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> ] On Behalf Of Axton Sent: 05 December 2006 17:10 To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> 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] <mailto:[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 <http://www.arslist.org/> ARSlist:"Where the Answers Are" __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
