SQL Search does not search synonym definitions

Comments

• Eddie D Redgate › Posts: 1,803 Rose Gold 5

  November 25, 2016 8:27AM

  Hi, thank you for your forum post.
  
  I have added the details of this forum post to an existing enhancement request 'Support Synonym Searches'. The reference for this enhancement is SDI-695.
  
  You may also wish to vote and comment on this SQL Search User Voice Forum Post (If you have not already done so). Hopefully you will see this feature added to a future version of SQL Search.
  
  Excellent news that you like the tool.
  
  Many thanks
  Eddie

  Eddie Davis
  Senior Product Support Engineer
  Redgate Software Ltd
  Email: support@red-gate.com

  0 · Share on Twitter
• jimVisage1980 Posts: 22 Silver 1

  December 13, 2016 6:33AM

  I second this change.
  Also, can I request that the enhancement also includes searching for a match on the 'server' attribute of a synonym.

  0 · Share on Twitter
• Stoop Posts: 2 New member

  February 7, 2018 4:12PM

  I second that this is a great tool.
  Any idea when this will be added?

  0 · Share on Twitter
• RichardL Posts: 417 Gold 4

  February 9, 2018 1:39PM

  Hi @Stoop and @jimVisage1980
  
  Thanks for both of your posts.
  
  There are no current plans to support Synonym definitions within SQL Search.
  
  Feel free to add your suggestion to the Uservoice forum for future consideration though as @Eddie D suggested. The link is below.
  
  https://redgate.uservoice.com/forums/101149-sql-search

  Customer Support
  Redgate Software
  

  0 · Share on Twitter
• kondrich Posts: 80 Bronze 2

  October 13, 2020 9:41AM

  This is really a pity. SQL Search seaches everywhere, even in job step definitions, but it misses to seach in column base_object_name in sys.synonyms even in version 3.5.2.
  
  We would greatly appreciate to see this in SQL Search. We just missed several linked server occurrences in databases because they were encapsulated in synonyms that were not found.
  

  Regards, Klaus

  0 · Share on Twitter