This is good information to know. Thank you for the question.

In the URL given in the explanation, the phrase "The resource database (mssqlsystemresource)" appears four times....

Derek, you are absolutely right! Your example works "as-is" on SQL Server 2005 in native mode. So "Query sys.columns.is_identity for a value of 1" written as

select * from...

Hmmm... it depends on your point of view. If you view the syntax literally, then only one answer is correct.

However, if you view the possible answers as pseudocode,...

Hugo,

Thanks for the great explanation. It's humbling to know that my best guess wasn't good enough. This knowledge is far more valuable than points.

Thanks!

As mentioned in the Project Server TechCenter on TechNet:

http://technet.microsoft.com/en-us/library/cc197608.aspx

Three SQL Server 2005 Analysis Services components must be installed on the Project Server application server. If all of them are not...

Hmmm.... I assumed the question was specifically about pages, extents, and allocations in SQL Server. I had no idea that it was about general computer storage. Missed it, not...

Like many others, I missed the question, but I learned something today. In my world, that evens the score.

In hindsight, it's a good question. I'm glad that...

For SQL Server 2008 the value is 100

BOL:

http://msdn2.microsoft.com/en-us/library/bb933794(SQL.100).aspx

I found "Module Signing" in the BOL here:

http://msdn2.microsoft.com/en-us/library/ms345102.aspx

SQL Server 2005 introduces the capability to sign modules within the database, such as stored procedures, functions, triggers, or assemblies. Note that data...

In my case, like many others, the second answer was the only correct one. My birthday is not until September.