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

229 reads

Blogs

Microsoft Purview FAQ

By

I get many of the same questions about Microsoft Purview, so I wanted to...

Undercover Catalogue 0.4.5 Released – Database Module Bug Fix

By

Full documentation on the Undercover Catalogue can be found HERE We’ve spotted a bug in...

Saving Emergency Space on my Laptop

By

With my new laptop, one of the things I realized I’d forgotten to do...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

How to Add a New Shared Disk to a WSFC as a SQL Resource

By muhkam

Comments posted to this topic are about the item How to Add a New...

Error Login from an untrusted domain

By Deni Kusdeni

Hi All, I found something a little strange in my SQL Server Error Log,...

Visit the forum

Question of the Day

Disabling Indexes

I want to disable an index so that it doesn't use any resources and isn't maintained. I am planning to drop this, but don't want to do it now. The index is named LoggerNCI and was created on the dbo.Logger table, on the LogID column. What code disables this?

See possible answers