Solved

Partially Contained Databases - Cross Database Queries

Posted on 2016-11-21
3
61 Views
Last Modified: 2016-11-23
Please experts

any example about: Partially Contained Databases - Cross Database Queries
0
Comment
Question by:enrique_aeo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 28

Expert Comment

by:Pawan Kumar
ID: 41896937
Contained Db's - Feature of SQL 2012.  They are isolated from other databases and also from the instance that host the db.

Try microsoft/blog urls..

https://msdn.microsoft.com/en-us/library/ff929139.aspx
https://msdn.microsoft.com/en-in/library/ff929071.aspx
http://www.sqlcoffee.com/SQLServer2012_0009.htm

If you need something specific , please post ?
0
 

Author Comment

by:enrique_aeo
ID: 41897659
i need example (T-SQL) about  "Cross Database Queries"
0
 
LVL 28

Accepted Solution

by:
Pawan Kumar earned 500 total points
ID: 41898493
Below Microsoft URLs will help you with the cross database queries. <<Note>>

https://msdn.microsoft.com/en-us/library/dn584627.aspx
https://azure.microsoft.com/en-in/blog/querying-remote-databases-in-azure-sql-db/

Hope it helps !!
0

Featured Post

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server Results to Excel File 18 76
SQL trigger 5 32
SQL Recursion 6 33
MS Access TransferDatabase with ODBC - Receive Run-time error '2507' 1 23
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question