From e2ac7a52e2b09a349a703ba1e1a2911f4d3c0912 Mon Sep 17 00:00:00 2001 From: Mike Barry Date: Wed, 26 Oct 2022 08:02:33 -0400 Subject: [PATCH] Filter on user tables only --- lib/sqlalchemy/dialects/mssql/base.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/sqlalchemy/dialects/mssql/base.py b/lib/sqlalchemy/dialects/mssql/base.py index bf2cd9237e..2ba3f155bd 100644 --- a/lib/sqlalchemy/dialects/mssql/base.py +++ b/lib/sqlalchemy/dialects/mssql/base.py @@ -3228,7 +3228,7 @@ class MSDialect(default.DefaultDialect): # SQL Error [4103] [S0001]: "#v": Temporary views are not allowed if bool( connection.scalar( - text("SELECT object_id(:table_name)"), + text("SELECT object_id(:table_name, 'U')"), # U filters on user tables only. {"table_name": "tempdb.dbo.[{}]".format(tablename)}, ) ): -- 2.47.2