How many times have you wanted to quickly find an object on a server?
You don't know which database it's located in and there are 30+ databases on the server.
The following is a quick snippet that does this task. It's not very sophisticated but gets the job done.
-- Look for the object ColumnButtons across the server
-- Dave Winters 7/2011
exec sp_msforeachdb @command1 = 'use [?];
if object_id(''ColumnButtons'') > 0 print ''Found in: ?''; '