What are the possible restrictions with using synonyms on sql server (2005/2008) please?
Posted on 2010-11-12
What are the possible restrictions when using synonyms on sql server (2005/2008) please?
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.