Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

Old, but stable Expand / Collapse
Author
Message
Posted Friday, March 09, 2012 4:27 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, April 10, 2014 10:18 AM
Points: 1,769, Visits: 2,800
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
Posted Friday, March 09, 2012 4:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 05, 2014 6:41 AM
Points: 2, Visits: 53
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
Posted Friday, March 09, 2012 4:38 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 8:20 AM
Points: 4,862, Visits: 2,243
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
Posted Friday, March 09, 2012 5:36 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 10:18 AM
Points: 294, Visits: 1,008
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
Posted Friday, March 09, 2012 5:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 1:16 PM
Points: 3, Visits: 106
If it is not broken ... don't fix it ;)
Post #1264289
Posted Friday, March 09, 2012 6:02 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, April 03, 2014 10:21 AM
Points: 3,265, Visits: 321
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
Posted Friday, March 09, 2012 6:06 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:43 AM
Points: 1,201, Visits: 2,661
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
Posted Friday, March 09, 2012 6:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 28, 2014 12:46 PM
Points: 21, Visits: 242
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
Posted Friday, March 09, 2012 6:41 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, April 04, 2014 8:42 AM
Points: 598, Visits: 1,504
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
Posted Friday, March 09, 2012 6:41 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 11, 2014 12:58 PM
Points: 291, Visits: 517
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 »

Add to briefcase ««12345»»»

Permissions Expand / Collapse