At times we need to analyze the Size of the Database, or have to search the Object or Content in the Database, we always query system tables or create a script for self and some times we uses sp_depends,Query Analyzer and EM or SSMS but it has some limitations.
To reduce this effort we often try some third party softwares and we know that they comes at cost. Mohamed Bouarroudj of SQLDBTOOL has 3 software to help us out and yes they are FREE!!! There are 3 tools he has developed SQLDBDiff, SQLDBSearch and SQLDBSize.
1. SQLDBDiff: compares the schema and the data of SQL Server databases. SQLDBDiff supports SQL Server 2008, 2005 and 2000. Download SQLDBDiff from here
2. SQLDBSearch: find any object by its name or content in one or many SQL Server databases. SQLDBSearch supports SQL Server 2005 and 2000. Download SQLDBSearch from here
3. SQLDBSize: display size used or reserved by tables, indexes, databases, transaction logs and physical files graphically. Download SQLDBSize from here
