I am in agreement with the dissenters. The language used in the question infers that a yes or no is the only valid choice. I chose the "correct" answer...

I am not familiar with the xp_servicecontrol querystate option and cannot find any documentation on its use. In addition this option has a caveat to it. It works...

Hey kev,

this works in 2000!

Just thought after 15 pages that someone should let you know! 😉

Although the explanation is incorrect, today's question does achieve the objective of the QOD. It makes you think and generates discussion. Sometimes the QOD and the subsequent discussion...

I couldn't get my calculations to match any of the answers even after I used 50 and 100 for the nvarchar fields. I forgot that all the bit fields...

It is a bad query, but it will run in 2000 or in compatability mode. If this were a select into statement it would generate an error. In...

There sure has been a lot of traffic on this. This is what I think is an easy way to do this accurately.

select Case when Dateadd(yy,datediff(yy,DateOfBirth,getdate()),DateOfBirth) <=...

The formula is incorrect. If your birthday has occurred in the calendar year, the formula below returns 1 year less than it should. I know many people that...

If you haven't already looked at the links below, take a look at these two. SQL Server 2000 had issues in SP3. SP4 supposedly fixed these issues, but...

I have worked in many places that simply gave me keys to the kingdom, domain admin rights. I don't mind having that responsibility, but it opens you up to...