Login or Sign Up to become a member!

EXPERTS, INFORMATION, IDEAS & KNOWLEDGE

Social bookmarker Add this

Your profile

Search

July 2009
Mon Tue Wed Thu Fri Sat Sun
 << <   > >>
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    

XML Feeds

Authors

« The Manga Guide to DatabasesKilimanjaro is the code name for the next version of SQL Server »
The Data Management Journal

SSMS Tools PACK 1.1 - now with SQL Server Management Studio 2008 support

by SQLDenis


Permalink 07 Oct 2008 10:31 , Categories: Data Modelling & Design Tags: sql server 2008, sql server management studio, tools

Mladen Prajdić has updated his SSMS Tools PACK to work with SQL Server 2008.

Here are some of the cool new things



- Query Execution History (Soft Source Control) and Current Window History:
Save all executed queries to file or database and easily find them.
Current window history is a dockable window that show queries executed in a currently active window. There is also a search box at the top that filters results as you type


- Search Database Data:
Search for a value in all non-binary columns in all tables in the database

- Uppercase/Lowercase keywords:
Set all keywords to uppercase or lowercase letters. Custom keywords can be added. Doesn’t check comments, text and quoted text anymore.


- Run one script on multiple databases:
Run selected or full window text on selected databases on the currently connected server.

- Copy execution plan bitmaps to clipboard:
Copy selected or all execution plans to a bitmap that is saved on the clipboard.

- Search Results in Grid Mode and Execution Plans:
Find all occurrences of your search string in the execution plans or in the results in datagrid mode.

- Generate Insert statements for a single table, the whole database or current resultsets in grids:
Generate insert statement from your data.

- Text document Regions and Debug sections:
Add Regions and Debug section in your scripts to ease development experience.

- Running custom scripts from Object explorer’s Context menu:
Speedy execution of custom scripts from Object Explorer’s context menus.


- CRUD (Create, Read, Update, Delete) stored procedure generation:
Generate Customizable CRUD stored procedures for all tables in your database.

- New query template:
Create a template that is shown when creating a new query window.

Download SSMS Tools PACK 1.1 here: http://www.ssmstoolspack.com/Download.aspx

3 comments »Send a trackback » 901 views

Trackback address for this post

Trackback URL (right click and copy shortcut/link location)

3 comments

Comment from: Jerry Hung [Visitor] · http://www.jerryhung.ca
*****
YEAH, about time

There's only so much you can do with SSMS 2008 and Red Gate tools
10/08/08 @ 09:46
Comment from: Mladen [Visitor] · http://weblogs.sqlteam.com/mladenp/
*****
i can feel your enthusiasm :))
10/09/08 @ 02:52
Comment from: Jerry Hung [Visitor] Email · http://www.SQLServerNewbie.com
Installed it yesterday, noticed it has TEXT FORMAT function too to prettify the KEYWORDS

10/09/08 @ 08:10

Leave a comment


Your email address will not be revealed on this site.

Your URL will be displayed.
PoorExcellent
(Line breaks become <br />)
(Name, email & website)
(Allow users to contact you through a message form (your email will not be revealed.)