Click here to Skip to main content
14,268,370 members
Rate this:
Please Sign up or sign in to vote.
See more:
I want to access data from another database in SQL Azure. I tried querying with three part naming convention
[databasename].[schemaname}. [tablename} and also with four part naming convention
[databaseservername].[databasename].[schemaname}.[tablename} But getting exception:

Reference to database and/or server name  is not supported in this version of SQL Server.


What I have tried:

I tried querying with  three part naming convention
[databasename].[schemaname}. [tablename} and also with four part naming convention
[databaseservername].[databasename].[schemaname}.[tablename} But getting exception:

<pre>Reference to database and/or server name  is not supported in this version of SQL Server.
Posted
Comments
KDGOLE 30-May-19 2:49am
   
Hi, you can create a linked server to access data in your server to another server...https://www.sqlshack.com/create-linked-server-azure-sql-database/

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100