I'm embarrassed to admit that the error was mine. I was clicking on the checkmark next to the word 'execute' in the menu. It turns out that the...

I tried SET NOEXEC OFF

it didn't make any difference. I've kicked this up to our IS staff, maybe they'll figure it out.

Thanks for the help

I did check if I'm in the right database. I am. The query editor doesn't seem to be working correctly. Anything I can check (a service, etc.)...

I again ran the code using the name of an existing table in the database

SELECT *

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_NAME = 'baloon'

and the results said 'Command(s) completed successfully.' but no actual...

I ran

SELECT *

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_NAME = 'atest'

the result table is empty