What version of SQL Server (@@VERSION)? ..., 2017, 2019

Using SSMS? Or another client? SSMS

Does it work using #test rather than test? NO

Are you in master or another database? Do other...