SQL Search not returning Views?

GigaFluxx

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

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

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.

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

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. 

ashars

Danke! 

ashars

Thanks! Danke! What do you mean? https://my-ford-benefits.live/