Search for an Object in SQL Server
This article helps you in understanding how to Search for an object in SQL Server using T-SQL script. When we need to search for an object inside a database we can do that using sys.objects but when it comes to cross database search that needs a solution. There are different ways to search for an object in SQL Server:
- T-SQL Script: A native T-SQL script.
- Object Explorer Search: User required proper permissions to use this
- Red Gate SQL Search: It’s not always possible installing freeware on enterprise environments
- SSMS Tools Pack Add-in: An extra tool has to be added to SSMS
Why Instance level object search is required?
There are few cases where we search for objects across the instance.