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


Azure Analysis Services – Processing Hot & Cold Data using Tabular model partitions


Introduction Recently have been working on a “Proof of Concept” task where I wanted...

Extracting data from Common Data Services (Microsoft Dynamics 365) using Azure Data Factory


(2020-Mar-30) Little did I know that I can use Azure Data Factory (ADF) to extract...

Probing Columnstore Indexes


In this article, our focus will be to test, the performance benefits of columnstore...

Read the latest Blogs


Regarding for Microsoft Azure Certification

By Ankitdixit

Hello Everyone, I am new here and I am preparing for microsoft azure certification...

Parameter has any limit or size?

By ravisankar

Hi I have created report with Cascading parameter (Multivalued), Is there any limit or...

Newbie. Up date Table

By MrToad

Hi. New to SQL. There is a field I want to change within our...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers