Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

Data Management

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Your profile

Authors

Search

XML Feeds

Google Ads

« The Manga Guide to DatabasesKilimanjaro is the code name for the next version of SQL Server »
comments
Rate Post:
submit to reddit Digg!FacebookDotnetkicks

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

About the Author

User bio imageDenis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
Social SitingsTwitterFacebookLinkedInHomePageLTD RSS Feed
1185 views
submit to reddit Digg!FacebookDotnetkicks

Comments and Feedback

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.
(Line breaks become <br />)
(Name, email & website)
(Allow users to contact you through a message form (your email will not be revealed.)