Friday, January 29, 2010

Get Server Version and Additional Info

It is quite common to get the SQL Server version details from following query.

SELECT @@VERSION VersionInfo


Recently I have been using following SP to get version details as it also provides me few more information about the server where the SQL Server is installed.
EXEC xp_msver





I like to use the second one but again that is my preference.

No comments:

Post a Comment