How to find your SQL server version

Posted Oct 13, 2010 by Softminer
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

version 8 -> SQl 2000
version 9 -> SQl 2005
version 10 -> SQl 2008

when you connect through your MSSM (Microsoft Sql Server Management Studio) you can find your SQL version like following photo:

Permalink 0 comments
0
Responses to ... How to find your SQL server version

Post a Comment