Object Scriptr v1.0 for SQLServer 7/2000

Introduction
Often enough you might have a need to generate a script for a sqlserver database object such as a table, a view, a stored procedure or an user-defined-function. Also, you might have a need to generate some sample data along with the DDL (Data Definition Language).This software is intended to make it easier to quickly generate such script(s). The software is a SQL-DMO application written in VB and has been tested on SQL2K and backward compatible on SQL7.

License
You must read the license agreement in full and indicate your agreement to its terms prior to installing or using the software. All rights, title and interest not expressly granted are reserved.

Freeware
This software may not be distributed or bundled with any product that is sold for commercial profit without the explicit permission of the author.

The term freeware refers only to the mode of distribution, the executables and source are copyrighted. Reuse of this code in a commercial application is not permitted.

Disclaimer
The author hereby disclaims all warranties relating to this software, whether express or implied, including without limitation any implied warranties of merchantability or fitness for a particular purpose. The author will not be liable for any special, incidental, consequential, indirect or similar damages due to loss of data or any other reason, even if the author or an agent of the author has been advised of the possibility of such damages. In no event shall the author's liability for any damages ever exceed the price paid for the software, regardless of the form of the claim. The person using the software bears all risk as to the quality and performance of the software.

What's New

Version 1.00.19

• Remove timestamp from insert script generation

• New logo added
• Allow switching to another SQLServer without completely exiting out
• Overcome textbox buffer limit (64kb) by using richtextbox
• Sample rowcount setting is saved and reloaded on next run

• Address object ownerships correctly
• Handle Calculated/Computed columns correctly in Inserts

• Allow selecting all data via checkbox
• Handle Bit datatype correctly

• Handle Identity column correctly
• Handle DateTime datatype correctly
• Update site links

• Maximize window allowed
• Resize window allowed
• Split windows allowed

• Logo added

• Available Server List
• Remember login for later use
• Refresh
• Minor fixes

• Authenticate with either SQL login or Trusted
• Generate Drop/Create script for Stored Procedures
• Generate Drop/Create script for Views
• Generate Drop/Create script for User-Defined-Functions
• Generate Drop/Create script for Tables
• Generate Insert statements based user defined number

Usage
Using this software is quite straight forward. Upon launching the tiny executable, you will be prompted for a servername and/or instance, authentication login/password.

These information are stored in appropriate global variables and are only good for the duration of the running application. However, the utility does offer you the ability to save your information within the system registry for later use by select "Rememer Login" from File Menu..

Upon successful authentication, you will be brought to the main screen where you can drill down to any SQLServer's object and a script will be generated to textbox on the right.

If the selected object is a table, the ObjectScriptr will also generate some Insert Into statements for you based on the defined Sample Data value.

regsvr32 c:\mssql7\binn\sqldmo.dll /s