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: )

223 reads


Everyone Run a SQL Saturday in 2021


With SQL Saturdays being rebooted, and the website live, it’s time for events....

Modern Data Warehouse & Reverse ETL


An extension to the Modern Data Warehouse (MDW) that I have heard a bit...

Daily Coping 12 Apr 2021


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

Read the latest Blogs


Linked server to Access accdb database

By richardmgreen1

Hi all   We've got a linked server from SQL 2016  to an accdb...

performance tuning

By rohitkocharda

Hi everyone, Any good suggestion to tune below query:   --CREATE NONCLUSTERED INDEX nonclust_code...

Understanding the Internals of a Data Page

By Mohsin_A_Khan

Comments posted to this topic are about the item Understanding the Internals of a...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers