Logging In to Free PC Help Forum Has Changed

Lesson Learned #307:Reference to database and/or server name is not supported in this version

By Guest Jose_Manuel_Jurado
January 27, 2023 in Microsoft Support & Discussions

https://freepchelp.forum/topic/211628-lesson-learned-307reference-to-database-andor-server-name-is-not-supported-in-this-version/

Followers 0

Recommended Posts

Guest Jose_Manuel_Jurado

Posted January 27, 2023

Our customer got the following error message: Msg 40515, Level 15, State 1, Line 19 - Reference to database and/or server name in 'DbName.dbo.TableName' is not supported in this version of SQL Server, executing the following TSQL: select * into [DbName].[dbo].[TableName] from [TableName2]

As we mentioned, in this URL: Cross-database Query in Azure SQL Database. This requires accessing tables on different DBs using 3 part naming that is not possible in Azure SQL Database but in Azure SQL Managed Instance is possible.

If we need to use Azure SQL Database, the recomendation is to use external tables - Cross-database Query in Azure SQL Database