Feb
07
2009

SQL Tips – Identifying which version of SQL Server you are using

If you need to find out the version of SQL Server you are using, simply use the following script:

SELECT SERVERPROPERTY('productversion'),
       SERVERPROPERTY('productlevel'),
       SERVERPROPERTY('edition')
Written by John in: SQL Tips,Tips |

No Comments »

RSS feed for comments on this post. TrackBack URL

Leave a comment