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?
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.
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
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal