Click here to Skip to main content
15,884,177 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900