Finding your SQL Server Version

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

This article is old so may be outdated.

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

JavaScript

Setting a more specific database type in Prisma

Prisma sets a default of TEXT for all String fields, here is how you can override that.

Ruby

Override database attribute types

Sometimes you don't have control over how your database handles information, so you need Rails to set it