Finding your SQL Server Version

How I went about finding out what my current SQL server version was

One of our clients in the company I work for is running SQL Server 2000, how do I know this wonderful bit of information you ask? Well, let me tell you;

SELECT @@VERSION AS theVersion

This took longer than 30 seconds to work out, which is frankly too long, so hopefully I will save someone else the pain when trying to work out what version you are running when you have limited privileges.

I ran this in the "MASTER" database, I am not sure if this is required though.


Recent posts View all

Ruby

How to ignore Bullet in RSpec tests

Using Bullet during a test can pick up mistakes but also has false negatives; here is an easy way to ignore them

Ruby

How we used Nokogiri to fix a sizing issue in YouTube's oEmbed

At some point, one of our calls to YouTube's oEmbed endpoint was returning videos way too small; we fixed in in our Rails application by using Nokogiri