Script to find SQL Server Version

sqlserver2014

[Note: The is my 500th blog post!] You will sometimes need to find the version of the installed SQL Server instance. This is easily accomplished by running a simple query against the instance.

SELECT @@VERSION

This will return the version information.

You might need to know more information, and this article by Ahmad Osama does a good job of describing the required scripts.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s