Check if SQL Server version is 2005 or lower

This script shows a simple way to check if the current version of SQL Server is 2005 or lower.It exploits the new server property called 'BuildClrVersion' which is not defined on SQL Server 2000 (and lower) but has just been introduced with 2005.It may be useful to condition the execution of a piece of code […]

2007-08-16 (first published: )

222 reads


Daily Coping 1 Oct 2020


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

PASS Virtual Summit 2020 Conference Sessions


Whether you are a SQL Server Database Administrator or Infrastructure Architect, you should be...

Running Express Edition in a Container–#SQLNewBlogger


Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs


Internal Query Processor Error: The query processor could not produce a query pl

By YSLGuru

Is there a standard method for troubleshooting the below error? Internal Query Processor Error:...

How to extract string between variable characters?

By C-M-A

Hi All, I've got a nasty column that I need to get the name...

Making 1 row from 2

By SQLHeap

I'm struggling a bit here. It seems easy, but I 'm not getting it....

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers