[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

still on RTM - any problems?

Posted on 2011-09-15
2
Medium Priority
?
322 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 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

590 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