Solved

What are the possible restrictions with using synonyms on sql server (2005/2008) please?

Posted on 2010-11-12
2
880 Views
Last Modified: 2012-05-10
Dear Experts,

What are the possible restrictions when using synonyms on sql server (2005/2008) please?

In particular:
1) Can you have referential integrity between a 'real' table and a synonym table?
2) Are you likely to have any issues if you use a synonym instead of a 'real' table as a dimention in reporting services or analysis services (cube)?
3) If you update your source table (just the type on a field for instance) is that reflected straight away, or does the synonym require refreshing (same problem as with views)?
4) Anything else I haven't thought of here?

One thing I am aware of - is that you cannot chain them.

Your experience is probably more valuable than general links, and I would be grateful if you could answer at least some of these questions.

Thank you.

0
Comment
Question by:CallConnection
2 Comments
 
LVL 14

Accepted Solution

by:
Megan Brooks earned 500 total points
ID: 34129754
1. I don't *think* you can declare referential integrity between different databases.

2. Not that I am aware of. I use views to feed my dimensions, and some of those views reference synonyms.

3. There is nothing to refresh with a synonym.

4. For the most part, using a synonym is logically equivalent to referencing a database directly from another database using the dbname.schema.object syntax. The only differences I have encountered have been with the way synonym security works.
0
 

Author Comment

by:CallConnection
ID: 34143826
Thank you for your help.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

856 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