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

Search

XML Feeds

Google Ads

Tags: sql server management studio

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
1215 views
submit to reddit Digg!FacebookDotnetkicks

Comments and Feedback