<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQLServerCentral.com
»
Editorials
»
Old, but stable
58 posts, Page 2 of 6
««
1
2
3
4
5
»
»»
Old, but stable
Rate Topic
Display Mode
Topic Options
Author
Message
Gazareth
Gazareth
Posted Friday, March 09, 2012 4:27 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Monday, May 20, 2013 1:53 AM
Points: 1,474,
Visits: 2,342
I'm still having nightmares from trying (and mostly failing) to get SQL 2K to work with Crystal Reports.
Luckily the company was down to 3 monthly Crystal Reports by the time I started.
Of course, this was offset by the 1,000+ reports in SSRS...
Post #1264237
andrew.armitage 40391
andrew.armitage 40391
Posted Friday, March 09, 2012 4:30 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, November 14, 2012 7:43 AM
Points: 2,
Visits: 52
I work for a national media company in the UK. We use SQL 2000 for ETL of sales data, and DTS to generate daily reports, directly from which commissions are paid at the end of the month. I've been begging to be moved to one of the company's existing SQL 2005 platforms for years, but because the system works I'm told I'd have to come up with a compelling business case for it :¬/
Maybe it's time I encountered some problem which "can't be done in 2000 so we'll have to upgrade"...
Post #1264239
Gary Varga
Gary Varga
Posted Friday, March 09, 2012 4:38 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 3:14 AM
Points: 3,541,
Visits: 1,132
andrew.armitage 40391 (3/9/2012)
I work for a national media company in the UK. We use SQL 2000 for ETL of sales data, and DTS to generate daily reports, directly from which commissions are paid at the end of the month. I've been begging to be moved to one of the company's existing SQL 2005 platforms for years, but because the system works I'm told I'd have to come up with a compelling business case for it :¬/
Maybe it's time I encountered some problem which "can't be done in 2000 so we'll have to upgrade"...
In my experience it is a choice better left to others. Technical recommendations are just that. Recommendations.
This view is less to avoid taking responsibility for any results (when I recommend an action I have to stick by it anyway or change my recommendation) but more due to the scope of my recommendation tends to be technical and operational. Not financial and rarely involves business risk planning etc.
I see my opinion as input to the decision makers who control budget, resources and risk.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1264242
IceDread
IceDread
Posted Friday, March 09, 2012 5:36 AM
SSC Veteran
Group: General Forum Members
Last Login: Friday, November 16, 2012 3:47 AM
Points: 290,
Visits: 988
We do not use sql server 2000.
All thou we have sql server 2008, not the RC version... which is annoying and bad, apparently none or few before me pressed this issue. However there is work being done to prepare for sql server 2012.
Post #1264288
charles.brochu.1964
charles.brochu.1964
Posted Friday, March 09, 2012 5:39 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 9:11 AM
Points: 2,
Visits: 41
If it is not broken ... don't fix it ;)
Post #1264289
Lee Nadelman
Lee Nadelman
Posted Friday, March 09, 2012 6:02 AM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:59 AM
Points: 2,914,
Visits: 281
We still have one SQL 2000 server that we have converted almost all existing DTS packages to SSIS on SQL 2008. Once that is complete we'll be able to turn off this server.
Post #1264304
Markus
Markus
Posted Friday, March 09, 2012 6:06 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 5:14 AM
Points: 1,048,
Visits: 2,216
We have about 40% of all of our production databases still on SQL2000 and two are the biggest systems. One of them the rollout to our first 7 stores on a new version of the app and SQL2008R2 Cluster begins Monday. SQL2000 has been very stable over the years I must say. Obviously we are fast tracking what is left on SQL2000 to 2008 right now and have a handful of others in process and a bunch more in the planning stages since Extended support for 2000 ends 3/2013.
Post #1264307
Jim McCoy-259251
Jim McCoy-259251
Posted Friday, March 09, 2012 6:20 AM
Grasshopper
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 6:17 AM
Points: 21,
Visits: 236
Absolutely!!!! We have a number of applications which function quite adequately to their tasks that require 2000 and won’t integrate with anything newer. Unless those applications are replaced or upgraded 2000 will be around for a number of years yet. All of the instances have been moved to virtual environments because in many cases the physical boxes were beginning to fail however. 05 and 08 are more prevalent with new applications but the old “steady’s” will be around for years. One of the instances will eventually go as I move the DTS packages into SSIS but there are so many I have delayed my retirement, I’m an old old old fart, entered the desktop world using CP/M from the card punch world, to finish the moves and testing. Got to ease into that new existence called re-tired slowly testing as I go you know, just tired now without the re…….
Post #1264323
chrisn-585491
chrisn-585491
Posted Friday, March 09, 2012 6:41 AM
SSC-Addicted
Group: General Forum Members
Last Login: 2 days ago @ 7:32 AM
Points: 479,
Visits: 1,263
At the local user group, there is a significant number of folks that are still using 2000 and 2005. If it works well, the management says, why spend money and time to upgrade and test?
In local news my wife is still using Ford 1990 and I'm on Toyota 2009...
Post #1264335
EricEyster
EricEyster
Posted Friday, March 09, 2012 6:41 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 7:30 AM
Points: 125,
Visits: 229
Still running 2000 on one server. Biggest holdup is getting business sign off that their data will still be the same after the upgrade.
Post #1264336
« Prev Topic
|
Next Topic »
58 posts, Page 2 of 6
««
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
