SQL Server Synonyms - unable to view from SPSS


  • Hi All,

    I have a client who is connected to a database which has synonyms referencing tables in a different database on the same server. The client used SPSS wizard to see the table & views. Anyway, SPSS wizard shows buttons called tables, views, & synonyms and when client checks either the table or views buttons, they can see the tables and views. But when they click on the synonyms button, no synonyms show up even though they are in the database.

    Please help.



    Wednesday, October 6, 2010 2:33 AM