Having recently gotten my brains beat out, my integrity questioned, my intelligence derided and other wise vilified (Refer to the QOD 11/17/2009 forum). I am greatly surprised that the little bitty nitpickers are not raging here in this forum, perhaps it is because they do not intimately know enough about SQL Server or since they got the message they so dearly love to see, that is "You got it right".

But let me point out a technicality: The question asked which of these views would you query. The correct answer as given is sysobjects.

Now for the sorry bit of fact the displayed item: sysobjects is a SYSTEM TABLE

The VIEW is sys.sysobjects. Which of course contains essentially the same data as does the system table. To be more specific it is defined as a CATALOG VIEW, but a view nevertheless.

Now this should not be attributed as an effort to denigrate the author of this QOD, knowing how hard it is to compose an "acceptable" QOD.

VM-723206 I congratulate you on your adroit side stepping the nit pickers.