PNASoft
RSS feed

Summarize

Galleries: 68   Photos: 2224
Folders: 67   Files: 2221
Members: 34748      


SSMS Tools PACK

SSMS Tools PACK

Uppercase/Lowercase keywords
Set all keywords to uppercase or lowercase letters. Custom keywords can be added.

Run one script on multiple databases
Run selected or full window text on selected databases on the currently connected server. A new window is opened that contains one script for all databases.     

Copy execution plan bitmaps to clipboard
+ Copy selected or all execution plans to a bitmap that is saved on the clipboard. Large execution plans that don't fit in the window are also copied in full.
+ Width of a picture containing all execution plans is equal to the width of the widest execution plan.    

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
+ Insert statements for the whole database are generated by the order of PK-FK relationships. Top tables with no FK's are scripted first. Binary data is by default fully scripted. If you wish you can also set the scripting data limit between 0 and 10 Mb. Larger values then the limit are then scripted as NULL.
+ Insert statements for the data in result grids are scripted into a new temporary table for each grid. For example from 5 result grids insert statements for 5 temporary tables get created.

Query Execution History (Soft Source Control)
+ Every statement that you run is logged in a file on your disk or in a table in a database you specify with a connection string. This way, if you're working on some script you can get the full history of every change you've made between check-out and check-in of your file.
+ Actions are saved in a list that is written to a file and/or a database on a timer which you can set to a desired interval.

Text document Regions and Debug sections
Regions behave in the same way as in Visual Studio. You can collapse them and expand them. Debug sections are sections that get commented or deleted when you change your script to Release configuration. A debug section is also a collapsable region. If you deploy a script in debug mode with added debug sections it will fail when run from SSMS without SSMS Tools Pack installed. You can of course comment those sections yourself by simply searching for start and end text of the debug sections.

Running custom scripts from Object explorer's Context menu
You can specify a custom script text, its name and node on Object Explorer on which you want to run it from. Node name, current database, current connection string and current server can also be specified in the custom script with keywords that are replaced with their respective values at script runtime.

CRUD (Create, Read, Update, Delete) stored procedure generation
CRUD stored procedure generation for tables based on fully customizable templates that you can change to suit your needs.

New query template
When opening a new query window you can specify a template that will be displayed.

A greate freeware version for SQL Server. Always check your homepage for update newer version.

What included in the download file at pnasoft
1. Setup version file
2. Freeware version.


Google bookmark Yahoo bookmark Digg bookmark Furl bookmark Reddit bookmark Slashdot bookmark Stumbleupon bookmark Technorati bookmark Blinklist bookmark Newsvine bookmark Netvouz bookmark Wists bookmark Blogmarks bookmark Spurl bookmark Shadows bookmark Facebook bookmark
Placeholder for Google Adsense
Placeholder for Google Adsense



Comments

thepawn said:

Thanks for good jobs admin.

May 20, 2008 9:11 PM

thepawn said:

Thanks again.

May 20, 2008 9:17 PM

msadeqian said:

i test this tool it's worked correctly and it's good tool

May 21, 2008 1:21 AM

romrkl said:

thanks for sharing.

May 21, 2008 8:31 AM

hengfeb1 said:

A good tools for database adminstration.

May 22, 2008 5:47 AM

mauri160 said:

This tool is perfect if you are a database administrator. Thanks for share!!

July 28, 2008 7:45 AM

PhuocTri said:

Thanks.

September 22, 2008 9:35 AM
PNASoft.com does not store any files on its server.
Please contact the content providers to delete copyright contents. Copyright by PNASoft.com