Month: June 2010

Windows Server 2008

Find out which version of SQL you are running

I recently encountered a problem where we had to identify the versions of SQL Running on a few servers. I found the quickest and easiest method was to run a SQL query against the servers in SQL Management studio. The SQL query to run is: SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) This will give you …