Solved

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

Posted on 2010-11-12
2
878 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 13

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

757 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now