Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
A man who does not think for himself does not think at all. Thinking cannot be done by proxy
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


How Do I Find Out the version of SQL Server Service Packs have been Installed

A common question that I have to ask my clients, is "What version of SQL Server Service are you working on and what Service Packs have been installed?"

More often than not, the client does not know.


The quickest way to find out which version of SQL Server and its installed Service Packs is in either Enterprise Manager or SQL Server Management Studio, type the following T-SQL command:

If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us


Name *

Email Address *

Comment *

To prove you are human what is:

46 + 95 =