Solved

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

Posted on 2010-11-12
2
882 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
[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 Comments
 
LVL 15

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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

688 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