synonyms Archives

How to fetch the columns of the synonyms for linked servers in SQL server

By adminPosted on March 26, 2023

Question : I am using two servers local (SQL Server running on my system) and remote (SQL Server running on […]

By adminPosted on February 20, 2023

Question : The following is not working. I want to create a synonym on a column in SQL Server 2017. […]

By adminPosted on January 5, 2023

Question : We are using oracle 11g, the db structure goes like this: We have users CST and FAS. CST […]

By adminPosted on December 4, 2022

Question : I have a table (OBJECTS_TO_UPDATE) with several objects I need to update, some are SYNONYMs for objects that […]

By adminPosted on November 29, 2022

Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]

By adminPosted on October 7, 2022

Question : I have exported users HR,Fin AND imported into new users HR1,FIN1 in the same DB. The expdb is […]

By adminPosted on September 8, 2022

Question : I have a view that I can access through a database link as such: SQL> select count(*) from […]

By adminPosted on June 26, 2022

Question : I have a user who has permission to create synonym in my sql server 2016 database.That user also […]

By adminPosted on May 14, 2022

Question : I have a table called diary. I insert several messages into it almost every day. I sometimes, for […]

By adminPosted on April 1, 2022

Question : I am trying to query the Oracle ALL_SYNONYMS view, but filtering by OWNER=PUBLIC returns both synonyms I have […]