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

Talk CSS

FrontEnders - Web Performance

Sharing some of my thoughts on a FrontEnders meetup on the topic of Web Performance

Conferences

Tips for how to ask for time off to attend conferences

Asking for time off to attend a conference can be nerve-racking, these tips will get you closer to attending the conferences you're interested in.