|
|
|
|
|
SQL-Programmer IX SP2 with TSQL Debugger 1 2 3 4 5 6 7 8 9 10 11 12 The Access Manager is the no nonsense interface to get to the objects you need to work with when you know exactly what you are looking for. This is also the place to go if you want to open or edit multiple objects at once. Within the Access Manager you can enable or disable source code control, enable or disable batch objects, edit objects, execute stored procedures, get query plans and statistics, view arguments for procedures, get dependencies and references for any object, bind rules and defaults, create and manage indexes, generate scripts, and print a list of selected objects. Deep breath. The script generation feature is very nice in that it runs in the background allowing you to continue on with your work. (This simply launches the Scripting module.) The Reporting module can also be launched from here simply by selecting print for any object(s) selected. This is the interface where you would go to extract and work with multiple objects. The number of objects is not a barrier. I have extracted a couple hundred objects in a single operation before. The only complaint I have is that the extraction does take quite a bit of time, but you can get used to it.
When extracting multiple objects, they will display in a separate window. In the figure below you can see the style that is used within SQL-Programmer. Syntax coloring is the most flexible of any tool I've used. 13 different items have specific color codes and all of the colors are configurable.
SQL-Programmer IX SP2 with TSQL Debugger 1 2 3 4 5 6 7 8 9 10 11 12 |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
