Feeds:
Posts
Comments

Archive for the ‘SQL’ Category

How can I find out which SQL Version is installed on the system?

Posted in Database, SQL on August 23, 2011| Leave a Comment »

Problem

How can I find out which SQL product and version  is installed on my server?

Solution

  • If your database server is installed on windows 2003 , go to start > Programs > Microsoft SQL Server 2005/2008 > SQL Server Management Studio

             

  • If your database server is installed on windows 2008 , go to start > Microsoft SQL Server 2005/2008 > SQL Server Management Studio

             

  • If your database server is installed on windows 2008 R2 , go to start > Microsoft SQL Server 2005/2008 > SQL Server Management Studio

             

  • Stand on one of the databases > Right Click > New Query, and write the following syntax:

             SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

  • Run the query by pressing “Execute” .
  • I received for example the following output: 9.00.3042.00 | SP2 | Enterprise Edition

             

  • Afterwards , check in the table below  for your product version . for example I searched for “9.00.3042“ and I saw that I have “SQL Server 2005 Service Pack 2” – Enterprise Edition from the output above.
Release Product version
SQL Server 2008 R2 Service Pack 1 10.50.2500.0
SQL Server 2008 R2 RTM 10.50.1600.1
SQL Server 2008 Service Pack 2 10.00.4000.00
SQL Server 2008 Service Pack 1 10.00.2531.00
SQL Server 2008 RTM 10.00.1600.22
SQL Server 2005 Service Pack 4 9.00.5000.00
SQL Server 2005 Service Pack 3 9.00.4035
SQL Server 2005 Service Pack 2 9.00.3042
SQL Server 2005 Service Pack 1 9.00.2047
SQL Server 2005 RTM 9.00.1399

 

Fixed!

Idit 🙂

Read Full Post »