Finding your SQL Server Version

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 install a beta version of Rails

This article will show you how using the gem command you can install beta versions of Rails

Ruby

The Welcome to Rails image is more inclusive

When playing with the new beta of Rails I noticed a more inclusive image