http://sqlblog.com/blogs/denis_gobo/archive/2007/09/24/2664.aspxDrag And Drop Column Names In Query Analyzer you can save a lot of time by using this trick instead of typing all the column names of a table Hit F8, this will open Object Browser Navigate to DatabaseName/TableName/Columns Click on the column folder andenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/denis_gobo/archive/2007/09/24/2664.aspx#2674Tue, 25 Sep 2007 14:02:44 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:2674Mladen<p>this is just shameless advertising of free stuff :))</p> <p><a rel="nofollow" target="_new" href="http://weblogs.sqlteam.com/mladenp/archive/2007/09/20/SSMS-Tools-Pack---an-add-in-for-SQL-Management-Studio.aspx">http://weblogs.sqlteam.com/mladenp/archive/2007/09/20/SSMS-Tools-Pack---an-add-in-for-SQL-Management-Studio.aspx</a></p> <p>you might enjoy running custom scripts from the context menu...</p> http://sqlblog.com/blogs/denis_gobo/archive/2007/09/24/2664.aspx#2680Tue, 25 Sep 2007 19:45:19 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:2680Michael Aaron Griffey<p>Drag And Drop Column Names </p> <p>Why stop at just column names? You can drag and drop table names, stored procedure names, users, exc... This helps alot when you have a schema name like QuestionSeries with tables like Old_to_New_Question_Number and QuestionResponse. Stored procedures can get rather lengthy as well. (ex. ThatOneApplication_DoSomeStuffToTheTable) &nbsp;</p> <p>You can also use window’s program specific hotkey functions to program way more that 12 hotkeys for any program you have running. The keys behave differently depending on which application is &nbsp;“Active”.</p> http://sqlblog.com/blogs/denis_gobo/archive/2007/09/24/2664.aspx#2695Wed, 26 Sep 2007 10:15:59 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:2695PeterW<p>Don't forget Template Explorer in SSMS - Ctrl+Alt+T</p> http://sqlblog.com/blogs/denis_gobo/archive/2007/09/24/2664.aspx#2987Mon, 15 Oct 2007 15:57:09 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:2987chenthorn<p>What do you do when drag/drop doesnt work? is there an option to check? All I get is a mouse pointer with a plus sign under it. I havnt found a key combo other than escape that does anything to drop the text on the my query window. thoughts?</p> http://sqlblog.com/blogs/denis_gobo/archive/2007/09/24/2664.aspx#26579Tue, 29 Jun 2010 23:40:26 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:26579ellai<p>More shameless advertising... =D</p> <p>If you are still using SSMS 2005 there's a new plugin available that is basically a solution explorer replacement and has common sense tasks like structuring queries, creating folders query sorting etc...</p> <p>Give it a try &lt;a href=&quot;<a rel="nofollow" target="_new" href="http://www.ssmsprojectplugin.com/&quot;">http://www.ssmsprojectplugin.com/&quot;</a> title=&quot;Management Studio 2005 project plugin&quot;&gt;Management Studio 2005 project plugin&lt;/a&gt;</p>