Crollan.VSScript.Assistant

To run sp_help, press "Alt + 2";
To run sp_helpText, press "Alt + 3";
To search for tables by the table name, press "Alt + 4";
To search for tables by the column name, press "Alt + 5";
To search for dependencies, press "Alt + 6";
To search for stored procedures, press "Alt + 7";
To run "Select * from table", press "Alt + 0";

Crollan's SQL Server Management Studio addIn has lots of other powerful features. One of them is to automatically find out the potential ways to join tables. The addIn can be found on

/vsgallery/bf161b31-0826-4f07-905b-d5d09c1227bb or

http://crollan.com

Crollan.com