RE: SQL versions

Microsoft SQL Server 2005 has major changes with stored procedures (it
supports .net integration) and of course the database formats have now
moved from 8 to 9 (but it does support older databases).

SQL 2005 is amazing in comparison to 2000, especially when it comes to
replication and performance, or so we've seen so far. There also the
addition of reporting services.

Finally, and most importantly, SQL server mainstream support retired
08/04/08 but extended support ends in 09/04/2013
http://support.microsoft.com/lifecycle/?p1=2852 so this is probably the
reason behind the requirement.

Is this in conjunction with an IBM product?

Hope that helps

Mike

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John McKee
Sent: 22 February 2009 02:29
To: Midrange Systems Technical Discussion
Subject: SQL versions

I apologize for this question that is unrelated to System i. If
somebody can
answer this, or direct me to a site where I can get answers, I would
appreciate
it.

An application states that it requires SQL 2005 to run. Two questions
immediately come to mind:

1) Is SQL 2000 not mentioned because there is functionality in SQL 2005
that is
needed, or is SQL 2005 listed as a requirement solely due to the age of
SQL
2000?

2) If there are new functions in SQL 2005 beyond what SQL offers, what
are the
functions.


It is a long story why I am asking this.

Thanks.

John McKee

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


This electronic message contains information that is confidential and may be privileged. This electronic message is intended for the use of the addressee(s) only. If you are not the intended addressee, any disclosure, copying, distribution or use of the contents of this message is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality.

Although this electronic message and any attachments are believed to be free from any virus or other defect which might affect any system into which they are received or upon which they are opened, it is the responsibility of the recipient to ensure that they are virus free and to check that they will not adversely affect its systems and data. No responsibility is accepted by Northern Foods PLC (or any member of its group) for any loss or damage arising in any way from their receipt, opening or use.

Northern Foods Plc is registered in England with company number 471864. Registered office: 2180 Century Way, Thorpe Park, Leeds LS15 8ZB.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.