Didn't we have this same question three days ago?

Good to see so many people got it right though - at least we're learning! 😉

Rich, you'll see if you run the given query that it actually works fine. No error is returned.

Hi Andy,

What's the latest on this contest?  Are we any nearer to finding a winner?

I am very interested to see some of the other solutions to this problem.

James

What happened to the answer for "none of the above"?  There is no such thing as a Server object - only a SQLServer object

From SQL 2000 BOL:

SQL Server must be able to resolve unambiguously the modification operation to specific rows in one of the base tables referenced by the view. You cannot use...

You cannot do this as the update references two tables

In the update statement, you are trying to update a column from more than one table (ie CustomerName from...

As much as I'd love for this fascinating thread to continue...

fhanlon, I can't help but notice you've worked your way into a corner here.  Check your last post and the definition of...

Initially, I too thought the lack of comma may have been a "trick" in the question - but then I tried it out and realised that it didn't matter.

I would...

Also:

- can we assume that scores are entered in sequence, ie the RowID can be used to get the order that balls were thrown?

- will the table hold the scores...

This isn't really the right forum for this question but...

SELECT DB_NAME()

John, you can see the full questions on the QOD home page:

http://www.sqlservercentral.com/testcenter/qod.asp

On first glance it seems that this is a very ambiguous question.  However, you could argue that the DATEPART function would return different, possibly confusing, results depending on any SET DATEFIRST statements that...

Clarification, from BOL:

SUSER_NAME always returns NULL when used in Microsoft® SQL Server™ 2000. This system built-in function is included only for backward compatibility. Use SUSER_SNAME instead.

The fact that it is marked as a user table in sysobjects does not change the fact that the dtproperties table is actually a system table.  If I indicate my...

I would like to take issue with this question.  The script as written will attempt to update permissions for the dtproperties system table (this table contains information about database diagrams) as...