This article covers how to find or search object and text in MSSQL Server database. I have recently found that there is a free tool/ SSMS add-in to perform this task very effectively. Before that I have many set of complex script to perform each and every task separately and however dependency analysis was not possible via T-SQL. There are can be many tools or add-in, this is article I am covering ApexSQL Search, a free SQL Server Management Studio for SQL Server database object and text searching and for dependency analysis. Even system objects can be searched.
Once you installed, to use, right click the database or any other object from the Object Explorer, you can see the ApexSQL Search menu.
Database Text Search
Database Object Search
View Dependencies
Edit Extended Properties
Cheers!
Uma
No comments:
Post a Comment