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

241 reads

Blogs

PASS Keynote Shots

By

Rodney Kidd took some great shots of the keynote and published an album here:...

Microsoft AI Red Teaming Course

By

here is the compiled video of the Red Teaming course Microsoft put together.

What’s New at AWS re:Invent 2025 – Day2 Highlights

By

Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote...

Read the latest Blogs

Forums

Fabric Mirroring

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Fabric Mirroring

T-SQL in SQL Server 2025: The UNISTR Function

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

How Important Are Real Time Decisions?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Important Are Real Time...

Visit the forum

Question of the Day

Fabric Mirroring

In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?

See possible answers