The Error Message:
Msg 4111, Level 15, State 1, Line 1
The CREATE SCHEMA statement should be followed by a name or authorization keyword.
is a run time error message introduced in SQL Server 2005. This error message appears when you try to create a new schema with CREATE SCHEMA without specifying anything else.
While creating a new schema you must specify either a schema name or an authorization keyword right after the CREATE SCHEMA command.
Example of such error generated is as follows
USE tempdb; GO CREATE SCHEMA