You are working for a company that has uses SQL 2012 for their on site databases. A fellow DBA is trying to do a quick check on a database by running this query:
I'm surprised that people are claiming that this statement proves the answer wrong. It's what led me straight to the correct answer.
They use SQL 2012 for their on site databases. Why include the qualifier "on site"?
The DBA is doing a quick link on "a database" - rather than "one of these databases".
Ah - "on site" is included, because "a database" is somewhere else. So could be on a server hosted at a different site, in which case the answer is SQL2000. Or it could be in the cloud. Which is more likely? They're using SQL2012, so less likely that they're using SQL2000 elsewhere. Of course the company might have just bought another company who were 15 years out of date in their technology, but the balance of probabilities seemed to favour the cloud 🙂