I use a combination of SQL Hunting Dog http://sql-hunting-dog.com/ (quick search all object names) and a SQL script from the (free) SSMSBoost plugin that looks at most object definitions but not table columns unfortunately. I've used Red Gate's SQL Search in the past but it's always been slow and buggy over the VPN.
If you're looking for a better execution plan utility, check out SQL Sentry's Plan Explorer. It's free.
I use a combination of SQL Hunting Dog http://sql-hunting-dog.com/ (quick search all object names) and a SQL script from the (free) SSMSBoost plugin that looks at most object definitions but not table columns unfortunately. I've used Red Gate's SQL Search in the past but it's always been slow and buggy over the VPN.
If you're looking for a better execution plan utility, check out SQL Sentry's Plan Explorer. It's free.