Is it correct that SQL Search does not return hits on schema name?

hansjp

When I search for all objects across databases with the same schema, say "qi", SQL Search only returns tables, views, stored procedures, etc. when they are referenced! That is: I only realise that a table belongs to a certain schema, when I have, say, a stored procedure selecting from said table. And then, I only get a pointer to the stored procedure, not a fast-click-way to the table in question.

I don't see why this should be, but on the other hand, I don't see what is wrong with my settings either.

RichardL

Hi @hansjp

Thanks for your post. 

I suppose the thing is that Search is searching for objects that contain the text you put in to the field. At the moment is doesn't do the kind of search you're looking for but please do feel free to make the suggestions for future implementation on our SQL Search Uservoice page in the link below. 

https://redgate.uservoice.com/forums/101149-sql-search

Kind regards

Richard Lynch.