Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Old, but stable


Old, but stable

Author
Message
Gazareth
Gazareth
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2872 Visits: 5351
I'm still having nightmares from trying (and mostly failing) to get SQL 2K to work with Crystal Reports. Crazy Crying


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... Blink
andrew.armitage 40391
andrew.armitage 40391
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 55
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"...
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8391 Visits: 6166
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!!!
IceDread
IceDread
Old Hand
Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)

Group: General Forum Members
Points: 329 Visits: 1145
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.
charles.brochu.1964
charles.brochu.1964
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 135
If it is not broken ... don't fix it Wink
Lee Nadelman
Lee Nadelman
SSCarpal Tunnel
SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

Group: General Forum Members
Points: 4319 Visits: 476
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.
Markus
Markus
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1587 Visits: 3680
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.



Jim McCoy-259251
Jim McCoy-259251
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 258
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…….
chrisn-585491
chrisn-585491
SSC Eights!
SSC Eights! (964 reputation)SSC Eights! (964 reputation)SSC Eights! (964 reputation)SSC Eights! (964 reputation)SSC Eights! (964 reputation)SSC Eights! (964 reputation)SSC Eights! (964 reputation)SSC Eights! (964 reputation)

Group: General Forum Members
Points: 964 Visits: 2321
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... :-P
EricEyster
EricEyster
SSC Veteran
SSC Veteran (296 reputation)SSC Veteran (296 reputation)SSC Veteran (296 reputation)SSC Veteran (296 reputation)SSC Veteran (296 reputation)SSC Veteran (296 reputation)SSC Veteran (296 reputation)SSC Veteran (296 reputation)

Group: General Forum Members
Points: 296 Visits: 520
Still running 2000 on one server. Biggest holdup is getting business sign off that their data will still be the same after the upgrade.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search