One benefit to using SQL Server 2005 is the ability to use .Net 2005 code for functions and stored procedures. Stephen
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Tuesday, December 05, 2006 10:36 AM To: [email protected] Subject: Re: Database ** A large benefit you will get moving to MSSQL Server is the use of stored procedures to return results sets through Set Fields action. This not allowed in Oracle so you have to hard code SQL statements. On 12/5/06, Rick Cook <[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 <[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 <http://www.arslist.org/> ARSlist:"Where the Answers Are" __20060125_______________________This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
