there are couple of good tools provided by redgate http://www.red-gate.com/products/dba/ (Disclaimer: i am not paid by redgate for this 😀 ).
i have used spotlight too , and found is quite handy
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)