6

We have using two databases that is used for cross database queries.One is named azureDB1 and another is azureDB2.These databases resides on my Azure cloud SQL Server.Our scenario is to call a stored procedure that resides in azureDB2 from azureDB1.For this we have tried to create a linked server using "sp_addlinkedserver" stored procedure.But we got error message that "Could not find stored procedure 'SP_ADDLINKEDSERVER'". We need solution for create linked server in sql azure server

juvchan
  • 6,113
  • 2
  • 22
  • 35
Jithin Joy
  • 483
  • 4
  • 15
  • This isn't a duplicate. This is asking about creating a linked server "from" Azure. The other is asking about creating a linked server "to" Azure. – David Dec 01 '17 at 16:14

1 Answers1

14

Linked server for Azure SQL Database is not supported. However you can use Elastic Query which allows you to query across SQL Databases https://azure.microsoft.com/en-us/documentation/articles/sql-database-elastic-query-overview/

ckarst
  • 751
  • 5
  • 11
  • 3
    Specifically, take a look at the sp_execute_remote stored procedure. It allows you to invoke a stored proc in a remote database in SQLDB. – Torsten Grabs May 25 '16 at 16:35