Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Expect the best, plan for the worst
 
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!!!!

13
December

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.


Solution:

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:
SELECT @@VERSION

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

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

83 + 94 =