<div>
<a href="http://technet.microsoft.com/en-us/library/ms188279.aspx" rel="ugc">Configure linked servers</a>, and use 3 or 4-part object references within the stored-procedure, here's the 4 parts:<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;server.database.owner.obje<wbr />ct<br />
<br />
Often, the owner is dbo, so people omit it, 3-part obj-ref example:<br />

<pre><code id="code-20-39795069-1">SELECT	*
FROM	Database1..table1	a
JOIN	Database2..table2	b	ON	a.key = b.key</code></pre>
</div>


Configure linked servers [http://technet.microsoft.com/en-us/library/ms188279.aspx], and use 3 or 4-part object references within the stored-procedure, here's the 4 parts:
      server.database.owner.object

Often, the owner is dbo, so people omit it, 3-part obj-ref example:


SELECT	*
FROM	Database1..table1	a
JOIN	Database2..table2	b	ON	a.key = b.key

<div>
Where do the linked servers reside, in the Azure SQL Server or in a local SQL Server DB that is managed by SSMS?
</div>


Where do the linked servers reside, in the Azure SQL Server or in a local SQL Server DB that is managed by SSMS?

<div>
<div class="content wysiwyg-content">
I would like to join 2 Databases on my Azure cloud SQL Server, in an Azure cloud SQL Server stored procedure. From what I've read it's not so simple. Is there any solution?<br />
<br />
Also, what's the best way to modify a cloud SQL Server stored procedure?
</div>
</div>


I would like to join 2 Databases on my Azure cloud SQL Server, in an Azure cloud SQL Server stored procedure. From what I've read it's not so simple. Is there any solution?

Also, what's the best way to modify a cloud SQL Server stored procedure?

Azure - Join 2 Azure SQL Server databases

Cloud computing, also known as on-demand computing, is a kind of Internet-based computing where shared resources and information are provided to computers and other devices. It is a model for enabling ubiquitous, on-demand access to a shared pool of configurable computing resources. Cloud computing and storage solutions provide users and enterprises with various capabilities to store and process their data in third-party data centers, relying on sharing of resources to achieve coherence and economies of scale.

Cloud Computing

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.