A common question I receive is that how do user know which version user is using and what is the latest version available for the product. Here is something at this beginning of the year, check with your production server. See if you are using the latest version of the product or if you need to upgrade. If you need to upgrade you might want to plan it with your entire team. As I get this question often here is something I have already built and kept it with me. As soon as I receive an email with the question about the version, I right away send it to them.
Now onwards as I have blogged about this subject, in future question, I will like to this blog post. Please feel free to add more details if I have missed any.
Here are two of the methods, you can use to identify your SQL Server version:
Open SSMS and in a New Query Window run following T-SQL code.
If you are still using SQL Server 2005 – I suggest that you consider migrating to later version of the SQL Server 2008/2008 R2. Due to any reason, you wanted to continue using SQL Server 2005, I suggest that you take a look at the Feature Pack for Microsoft SQL Server 2005 SP4. There are many different tools and features available in pack, which can be very handy and can solve issues.
Microsoft Core XML Services (MSXML) 6.0
Microsoft OLEDB Provider for DB2
Microsoft SQL Server Management Pack for MOM 2005
Microsoft SQL Server 2000 PivotTable Services
Microsoft SQL Server 2000 DTS Designer Components
Microsoft SQL Server Native Client
Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider
Microsoft SQL Server 2005 Backward Compatibility Components
Microsoft SQL Server 2005 Command Line Query Utility
Microsoft SQL Server 2005 Datamining Viewer Controls
Microsoft SQL Server 2005 JDBC Driver
Microsoft SQL Server 2005 Management Objects Collection
Microsoft SQL Server 2005 Compact Edition
Microsoft SQL Server 2005 Notification Services Client Components
Microsoft SQL Server 2005 Upgrade Advisor
Microsoft .NET Data Provider for mySAP Business Suite, Preview Version
Reporting Add-In for Microsoft Visual Web Developer 2005 Express
Microsoft Exception Message Box
Data Mining Managed Plug-in Algorithm API for SQL Server 2005
Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies
Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007
SQL Server 2005 Performance Dashboard Reports
SQL Server 2005 Best Practices Analyzer
Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP4 .
SQL Server 2008 has been out for over two years and now a very significant Cumulative Update has been released. If you are using SQL Server 2008 then you must certainly install it to fix the various bugs.
On an average once a week I receive a question from my readers regarding what should be the sequence of hotfix and service pack. Not long ago, one of my regular readers who is using SQL Server 2000 asked me how can he improve the installation speed as he has to install 4 Service Packs to upgrade his server to SQL Server SP4 version. All these questions from my readers have prompted me to write down this small note. I hope this will clear some of the common doubts they have about this subject and they no longer would have to ponder over such issues
You do not need to install all Service Packs to upgrade your server version to the latest versions. Just install Latest Service Pack and Hotfix and you are done!
This might be the smallest tip I have given so far on my blog but I am just curious to know from you all if you already knew about the solution or came to know about it through my blog today. Based on your feedback, I will come up with small articles like this in future and solve your day-to-day queries.