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
midrange.com
