Knowing nothing about how schemas in SQL 2K, I guessed you would get a syntax error, wrongly as it turned out. But when I tried the script, it turned out that answer C. seems to be right after all, I get the error

Server: Msg 195, Level 15, State 10, Line 1

'SCHEMA_NAME' is not a recognized function name.

Is SCHEMA_NAME a SQL Server 2005 function?

David