To create a local temporary table, the owner specification
must be omitted. If you include the owner specification when creating
a temporary table, for example, CREATE TABLE
dbo.#temp(col1 int), a base table
is incorrectly created. This behavior is not new, but was not documented
previously.
When you declare a local temporary table, omit the owner specification. If you specify the same owner.table in more than one DECLARE LOCAL TEMPORARY TABLE statement in the same session, a syntax error is reported. This behavior is a change from previous versions.
