web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Problems getting synon...
Microsoft Dynamics SL (Archived)

Problems getting synonym to work with SL 2011 FP1

(0) ShareShare
ReportReport
Posted on by mtiepruitt 95

A client has a highly customized SL 2011 FP1 installation with numerous table names starting with "x". They would like to move these custom tables to either a different database or different schema (long story). I originally thought we could use synonyms for this -- simply move a given table and create a synonym pointing to its new location.

But when I try doing this with one table, named xCut, I get an error in the DbNav property (where the query is a simple SELECT * FROM xCut WHERE cut LIKE @parm1).

This seems to indicate the synonym is not working within SL. But I don't understand why.

Does anyone know if it's even possible to use synonyms with SL?

Thanks for any help!

Elton

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi Elton,

    No it is not possible to use synonym's within SL. Trying to use synonyms with the SWIM setaddr, fetch, etc... calls, those calls assume either a table or a view. When you first log into Dynamics SL, the system fetches a list out of sysobjects where type is U or V. It's not looking for type SN. So the system would not be aware of your synonym object and wouldn't know it existed.

  • mtiepruitt Profile Picture
    mtiepruitt 95 on at

    Thanks, Cory, for such a thorough and succinct explanation!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans