Solved

still on RTM - any problems?

Posted on 2011-09-15
2
293 Views
Last Modified: 2012-06-27
we just saw that sql 2005 version on this server is still RTM..

we are upgrading to SP4 right away..

I am sure we missing new benefits/syntax etc.. but were there dangers or problems we encountered even without realizing?

what is the worst that could have happened all these years that this was on RTM.. and that we did not realize?
0
Comment
Question by:25112
2 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
ID: 36545054
>>what is the worst that could have happened all these years that this was on RTM.. and that we did not realize?
That is a fairly wide-reaching query....

Honestly, I would think if it has been running successully as long as it has, then you're likely taking very good care of, and properly using, a good build.  There are numerous functions that are not available to you yet, and I would encourage the migration to v2008 R2 for many reasons, but... if it's not broken, don't fix it.


http://news.softpedia.com/news/SQL-Server-2005-SP4-RTM-Available-173546.shtml
0
 
LVL 5

Author Comment

by:25112
ID: 36546688
ok-
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Not selecting duplicate data 6 60
SQL Server 2012 express 24 40
SQL Restore Script - Syntax Error 8 104
Need help debbuging stored procedure 21 44
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question