|   | ![]() |
|
SQL-Programmer IX SP2 with TSQL Debugger 1 2 3 4 5 6 7 8 9 10 11 12 No development environment would be complete without the ability to generate a script. The second add-on module in SQL-Programmer is the SQL-Scripter. This setup is very similar to SQL-Documenter. You are given a 2 pane tree view where you can drill through and select objects. Those with an open book icon will be scripted.
Batch objects are unique to SQL-Programmer. We are all familiar with batches. We create them everyday and execute them. Batches that we run frequently get stored as files on a workstation. What happens if your workstation blows up? You probably aren't backing up your workstation. What if more than one person wants to use them? What if someone makes a modification to one and doesn't pass it around to everyone else? Batch objects eliminate this by storing batches on your SQL Server so that they get backed up along with your databases and are available for common use. In order to store batch objects, you have to enable it first. This can be done from SQL-Explorer or Access Manager. The documentation states that you have to be sa to do this, but that is not correct. All you have to have is create table permissions for the database you are enabling batch objects for. When you enable batch objects, a table named SQL_Programmer_Objects will be created. When you save a batch object, it is stored in this table.
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.