Macros
SQL Header
This macro inserts a general-purpose documentation header
in your SQL Server Stored Procedure. Include Purpose, Author,
Notes, Parameters, Returns, and Revision History sections.
Automatically uses current username in header.
Breakpoint Every Method
This macro puts a breakpoint on every method in all open
code windows. Especially helpful when debugging unknown
modules.
Close All but Active
Closes all code windows except the current one. This
should have been in Visual Studio from the start.
Collapse All to Definitions
Performs a Collapse to Definitions on all open code windows.
Copy Reference Path
When you need this macro, you really need it. Copies the reference
path entries from the currently selected project to all other
projects in the solution. Most useful in multi-developer environments.
Update All Web References
Runs through each project in the solution and updates
all web references in the project.
Scripts
Verify Read-only
This script checks the file in the current directory and
all subdirectories for non-read-only. Has a function that
identifies file extension filters to exclude. By default,
the script ignores Visual Basic binaries and VS user settings.
Find Text in DTS ActiveX Tasks
Searches all .DTS files in the current directory and searches
for instances of a string in the ActiveX script tasks. This
solution was provided in a Usenet posting.
Products
zNav Version 1.2 released 1/13/08
zNav is a utility program that uses Yahoo maps to build driving directions in an image format
compatible with the Microsoft Zune. Additionally, you can do a business search for a location
and create an image with the business name, address, phone number, and map.
For any business found, you can get driving directions to or from that location.
Requires .NET Framework 2.0.
Version 1.2 fixes a problem where maps could not be read from Yahoo and includes an automatic version
check on startup.
download now
Flickr rTagger
rTagger helps organize your Flickr photo collection by allowing you to modify
tags offline. This is a much more responsive application than existing web-based
applications. Requires .NET Framework 2.0.
download now
SQL Stored Procedure Generator 2.0
This application is recently updated with improved functionality and more features. The application lets you
generate SQL Server stored procedures based on a table schema. The SP's generated are:
- Get - Gets a single record from a table and returns
the fields in output parameters. Takes the PK as an input parameter. Now handles multi-field PKs.
- Save - Saves a single record using parameters and
returns the PK as an output parameter. Now better handles autonumber fields.
- List - Returns a resultset for the entire table
- Delete (new) - Deletes a row based on the primary key
Using these as a base for your database operations promotes consistancy.
Comments are included at the beginning of each procedure. Case is duplicated
as the tables and fields are defined. Requires .NET Framework 2.0.
download now
Export SP Text
With the recent change to Visual Studio 2005, it isn't possible to export each SQL stored procedure as a separate
file, like Visual Studio 2003 did. This utility will let you export each stored procedure and user defined function
from a databse to a folder, keeping each SP in its own file. Requires .NET Framework 2.0.
download now
NNTP Relay
This application will read articles from one usenet server and post the messages
to another server. The configuration file allows you to download one or 1000
newsgroups. Subsequent executions of the utility will only read the newest posts
in the newsgroup.
download now
Class Builder Addin for Visual Studio .NET 2003
This addin for Visual Studio provides a quick way to make classes with
private variables and public properties. Use this tool to make large
DTOs and other data entities.
download now
COM+ Administration Addin for Visual Studio .NET 2003
This addin allows creation and maintenance of Component Services from
within the Visual Studio IDE. You can perform the following actions
on COM+ packages:
- Start and stop packages
- Create, edit, and delete packages
- Add components by dragging DLLs into the package
download now
MP3 Playlist Generator
This console application will generate WPL (playlist) files
for all MP3 files in the current directory and optionally
all subdirectories. Can provide warnings for files that
exceed Joliet CD file name standards.
download now
VB Quick Exec
Somtimes you just want to execute a line or block of VB.NET code. You don't want to load
up Visual Studio, you don't want to create a project, compile and run it. You just want
to run a command. VB Quick Exec lets you do just that. It runs in your system tray and
acts like a VB.NET command line. You can execute a single command or batch a series of
commands. It's more powerful and faster than using Calculator. Just Quick Exec
? ((10*5)+(6/2))+47 to get 100. Try that with Calculator.
download now
CD Backup
This is a console CD Backup program. It is configuration file based and
spans CDs with uncompressed files. This program was written to solve two
problems: Allowing a CD backup program to be executed from the command line
using parameters (or config file), and having a CD backup without all the
files being stored in a proprietary image file.
This utility has a lot of potential for a business that has this need.
Contact 700cb Development for enhancements.
download now
SQL Diff
This application will compare two databases on the same or different Microsoft
SQL Servers. The application will compare Stored Procedure existence and
content and table existence and structure. This application is especially
valuable in enterprises where there are distinct development
and production environments.
download now
Like these tools? Need enhancements or customizations? Contact 700cb Development
to get a quote on tools, software, or complete solutions.