In options have default code to fire
could be "sp_help object" or "select top 10 * from object"
and maybe even custom code
for table "bob" return "select top 10 * from bob where date > ..."
When the user double clicks on an object, the above code is fired.
Results could either go to normal window, balloon or other 'redgate' style pop-up
Alternatively, when the cache refresh runs, get it to execute "select top 10 *" from each table, then display this instead of/as well as the existing schema def pop up
could be "sp_help object" or "select top 10 * from object"
and maybe even custom code
for table "bob" return "select top 10 * from bob where date > ..."
When the user double clicks on an object, the above code is fired.
Results could either go to normal window, balloon or other 'redgate' style pop-up
Alternatively, when the cache refresh runs, get it to execute "select top 10 *" from each table, then display this instead of/as well as the existing schema def pop up