Which Versions of SQL Server Do You Have?

Click here to monitor SSC

<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>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<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

Popular Topics

Home

Home » SQLServerCentral.com » Editorials » Which Versions of SQL Server Do You Have?

Add to briefcase

79 posts, Page 1 of 8

1 2 3 4 5 »»»

Which Versions of SQL Server Do You Have?

Expand / Collapse

Author

Message

Steve Jones - SSC Editor

Posted Thursday, October 20, 2011 10:56 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:26 PM
Points: 31,425, Visits: 13,738

Comments posted to this topic are about the item Which Versions of SQL Server Do You Have?

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1194121

Posted Friday, October 21, 2011 12:25 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 06, 2013 3:22 AM
Points: 111, Visits: 152

We have 2 x SQL2000 servers and 5 x SQL2008R2 servers. I have an ongoing project to migrate all databases to our new servers (SQL2008R2), but I do it inbetween other projects and that spare time seems to get less and less. We still have about 40% of our databases on SQL2000. Our mix of in-house applications to third party applications is about 70% to 30% and 90% of the third party applications were migrated to SQL2008R2, maybe because it's easier, less integration. Wink

Wink

5ilverFox
Namakwa Sands
South Africa

Post #1194136

Posted Friday, October 21, 2011 1:10 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 4:44 AM
Points: 1,087, Visits: 692

Probably about 5 on 2000 and a similar number on 2005, a couple set up on 2008, although we have not got many real projects running on 2008 yet, mainly for reasons outside our control. It may be that we miss that one out the way things are going!

Post #1194140

Posted Friday, October 21, 2011 1:17 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, October 21, 2011 6:46 AM
Points: 34, Visits: 12

We have 2 x SQL 2000 servers in our BI environment. In our OLTP production environment we have a couple of SQL 2005 servers running apps that don't support 2008 yet. And we also have a couple of SQL 2008 servers running an app that does support 2008.

The main reason our BI environment still runs on SQL 2000 is because we have a whole lot of DTS code and we haven't yet gotten around to migrating it to SSIS.

I would be interested to know how many other people are finding DTS a bit of an obstacle to their upgrade progress from SQL 2000.

Best Regards

Joe Trainor
Head of BI
Virgin Active South Africa

Post #1194142

Posted Friday, October 21, 2011 1:29 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 2:13 AM
Points: 1,505, Visits: 226

Due to limitations and support from vendors, we currently have over 80 servers running sql server 2000. 5 servers running 2005 and the rest is now 2008 R2.
... And we also have 1 running sql server 7.... but that is the most reliable one! Slow but reliable Smile

Smile

If we could we would just upgrade everything, but as you may well know.

Cheers

Post #1194147

Posted Friday, October 21, 2011 1:31 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 06, 2013 3:22 AM
Points: 111, Visits: 152

joe.trainor (10/21/2011)

I would be interested to know how many other people are finding DTS a bit of an obstacle to their upgrade progress from SQL 2000.

Yes, that is why 1 of our SQL2000 servers is still there.

5ilverFox
Namakwa Sands
South Africa

Post #1194148

Posted Friday, October 21, 2011 1:35 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:21 AM
Points: 1,052, Visits: 316

We support 7 production SQL Server 2000 with 8 test/development servers mainly supporting in house developed systems with a few third party applications including one third party where they don't seem to understand basic SQL Server... Ermm

Ermm

Until recently we had another third party application that still ran on 6.5. Luckily I didn't have to support that!

Post #1194151

Posted Friday, October 21, 2011 1:37 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:25 AM
Points: 179, Visits: 210

We support SQL 2005, 2008 and 2008R2 on the products we produce that I have been involved with. We dropped support for 2000 when MS dropped extended support. 1 product used DTS on SQL 2000 and getting rid of that was the best thing ever! DTS was the bain of my existence every time we released a new version of the product or had to change a DTS package (crashing IDEs are not fun).

Post #1194153

Posted Friday, October 21, 2011 1:38 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:21 AM
Points: 1,052, Visits: 316

joe.trainor (10/21/2011)
I would be interested to know how many other people are finding DTS a bit of an obstacle to their upgrade progress from SQL 2000.

Several hundred DTS written over the years is the main obstacle to stop our upgrades!

Post #1194155

Posted Friday, October 21, 2011 1:55 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, November 16, 2012 3:47 AM
Points: 290, Visits: 988

I do not know about all products in the entire company but in my department of IT we use sql server 2008. We always upgrade to the latest version when we revisit a product or start a new one. I'm at large Insurance company in Sweden, and insurance companies does their job well here usually so they do not have the band standing I've heard some have in usa where most of you on these forums live I believe.

Post #1194162

« Prev Topic | Next Topic »

Add to briefcase

79 posts, Page 1 of 8

1 2 3 4 5 »»»

Permissions

Expand / Collapse