Aug 19, 2013

Sql script to get Microsoft version of sql server


We can get Microsoft versions of sql sever by following sql query:

SELECT  @@MICROSOFTVERSION / 0x01000000 AS MSVersion

Value
Meaning
9
Sql server 2005
10
Sql server 2008

No comments:

Post a Comment