Sql Server Object Explorer: Is There a Search Functionality

Question

Hi,

I have downloaded the Dec 2012 version of the SSDT for the Visual Studio 2010.

I am wondering if there is a way to easily locate an object in the SQL Server Object Explorer in the SQL Server instance node (table, stored procedure, etc) using a partial name or something?  I am thinking along the lines of the Red Gate SQL Search functionality for the SQL Management Studio.

I noticed if you know exactly the name of the object you may try typing the name in the Explorer, but that is not realy useful when you have a large number of SQL object and you do not know exactly the name of the object.

Thanks

Answer 1

No that feature doesn't exist. I would be delighted if it did. If you vote for it at http://connect.microsoft.com/sqlserver/feedback let me know and I will definitely vote for it.

---

ObjectStorageHelper<T> – A WinRT utility for Windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Answer 2

Thanks for a quick reply.

Since I am quite new to the SSDT I wanted to make sure I am not missing anything since I could not find anything in the SSDT documentation on finding, browsing and searching objects in the Explorer.

I have created a feature suggestion in the SQL Server Connect feedback section:  https://connect.microsoft.com/SQLServer/feedback/details/775710/ssdt-sql-server-object-explorer-object-search#details

You can vote if you want to support this feature in the SSDT.

Thanks

Answer 3

Voted and commented. thanks.

---

ObjectStorageHelper<T> – A WinRT utility for Windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me