SQL Search not returning Views?

GigaFluxxGigaFluxx Posts: 1 New member
edited January 25, 2021 7:31PM in SQL Search
I know for sure it was returning views in the past, but now, no matter what I search, I only get tables and no views. Any suggestions?

EDIT: I did try re-indexing

Answers

  • Good Afternoon,
    Thanks for your inquiry and sorry to hear about your issue with SQL Search.
    Can you please try the following to help with your issue?
    • Disconnect your SQL server from SSMS Object explorer

    • close and reopen SQL Search

    • reconnect your SQL Server

    Sean Quigley | Product Support Engineer | Redgate Software

    Have you visited our Help Center?





  • tixextixex Posts: 1 New member

    You are using the AND operator in your 3rd query, that doesn't result in the combined result of the previous 2, it result in the intersection of them.

    If you use OR then it will result in the combination.

    Hi team, thanks for creating such an active forum. 
  • djhutsondjhutson Posts: 1 New member
    edited November 3, 2022 4:57PM
    GigaFluxx said:
    I know for sure it was returning views in the past, but now, no matter what I search, I only get tables and no views. Any suggestions?

    EDIT: I did try re-indexing
    I am getting the same issue and have tried re-indexing and @squigley suggested solution, but views are being excluded from the results

    SQL Search version 3.6.0.3167
    SQL Server Management Studio 15.0.18424.0
  • sharanupasharanupa Posts: 1 New member
    Employees access MyFordBenefits frequently. We have written an article on MyFordBenefits, which includes a guide to how to log into the website, after discovering the website recently. 
Sign In or Register to comment.