Link to home
Start Free TrialLog in
Avatar of CallConnection
CallConnection

asked on

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

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.

ASKER CERTIFIED SOLUTION
Avatar of Megan Brooks
Megan Brooks
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CallConnection
CallConnection

ASKER

Thank you for your help.