Cross-Database Ownership Chaining

I have two databases A and B. Need to see some data on B.
I know I can use Cross-Database Ownership Chaining in order to get
access on B. Are there any alternatives?
In other database systems I did this by setting up an Alias to
database B and specifing the account to use for the connection to B.
thanks,Hi,
Thanks for your post.
To let me better understand this issue, I would like to confirm a
conception from you:
Is the Cross-database Ownership Chaining as you referenced in the form of
"server.database.schema.table"?
SQL Server doesn't support custom database alias to reference the original.
If you use linked server, you can use sp_addlinkedserver to add a linked
server to the current SQL Server and specify the login account in the
remote server.
In addition to the chaining expression "server.database.schema.table", you
can use OPENQUERY or OPENROWSET to access the remote server.
For the usage of OPENQUERY and OPENROWSET, you may refer to SQL Server Book
Online.
If you have any other questions or concerns, please feel free to let me
know. It's my pleasure to be of assistance.
++++++++++++++++++++++++++++++++
Charles Wang
Microsoft Online Partner Support
++++++++++++++++++++++++++++++++
PLEASE NOTE: The partner managed newsgroups are provided
to assist with break/fix issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader:
microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, a
nd confers no rights.
========================================
==============