Technical Article

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 […]

You rated this post out of 5. Change rating

2007-08-16 (first published: )

225 reads


Removing a PowerShell Array Element–#SQLNewBlogger


I saw an article on this and realized I had no idea how to...

PostgreSQL Backup Failure


In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Dynamic Data Masking – SQL Server


Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...

Read the latest Blogs


Case statement to insert a new line in query output??

By jbalbo

Hi I need to insert a new line of my output when a condition...

Database Mail to work on Azure VM

By terry999

Trying to get Database mail working sending via or port 587 using ...

Small Transactional Table with Frequent Updates

By WoundedParrot

Hi All We have a 12 row on our platform that gets updated for...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers