• Don't suppose you know how to see SYNONYMS in a linked server.

    I have SYNONYMS set up on server b and on server a set the user with view definition of SYNONYMS but cannot see them in linked server only see tables and views. Can't see SP either

    Right now i can ony set up a view to see the data on servera and want the user to be able to run select * from mysynonym

    Just curious if even possible.