How can we help you today? How can we help you today?

SQL Search not returning Views?

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
GigaFluxx
0

Comments

6 comments

  • squigley
    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

    squigley
    0
  • tixex

    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.

    tixex
    0
  • djhutson
    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
    djhutson
    0
  • sharanupa
    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. 
    sharanupa
    0
  • ashars
    Danke!
    ashars
    0
  • ashars
    Thanks! Danke! What do you mean? https://my-ford-benefits.live/
    ashars
    0

Add comment

Please sign in to leave a comment.