Msg 4103, Level 15, State 1, Line 2
“%1!”: Temporary views are not allowed.
This error message appears when you try to create a temporary view, analogue to a temporary table.
The SQL statement cannot be parsed and further execution is stopped.
Error of the Severity level 15 are generated by the user and can be fixed by the SQL Server user. A temporary view cannot be created.
This error message was introduced with SQL Server 2005. In SQL Server 2000 and below error 4508 is raised instead.
CREATE VIEW #v
Instead of a temporary view you should use a stored procedure, a temporary table, or a UDF that returns a table.