Microsoft SQL Server Topics

Featured: Featured Stories | Picture Gallery

Animals Controlled By Instinct Man By Reason | NewUsersGuide

Chat11.com Web Bible11.com MyBibleCenter.com

Absolute Beginner's Guide to Computer Basics

How Computers Work, Seventh Edition

PCs for Dummies, Ninth Edition

Wired MAGAZINE

Fast Company

Maximum Pc - Non-disc Version

DVD - Triumph of the Nerds - 1996

DVD - Beginner's Java 2 v1.5 2004 on DVD

DVD - Beginner's Windows Server 2003 on DVD

Music - Strike on Computers

Microsoft SQL Server Topics

How to generate a "CREATE TABLE" script from an existing database in SQL server.

• Microsoft Sql Server Management Studio can make the CREATE TABLE definition. Open a databases, right click on one of it's tables, then choose the Create Table task. You'll need to do this manually with each table in the database, and also with each index.
• http://vyaskn.tripod.com/code.htm#tblscript - COM component that can be used in T-SQL to generate CREATE TABLE script <BACK>
  • This is a COM component (DLL) written in VB which connects to SQL Server and generates the CREATE TABLE script for a given table from given database. It uses SQL DMO object model to connect to SQL Server. You can use this component from VB or VC application as well as from stored procedures and T-SQL. The Zip file contains the VB code for the COM component, a VB project that shows the usage and a stored procedure sp_scripter which instantiates this component to generate CREATE TABLE scripts. This procedure uses OLE Automation procedures such as sp_OACreate, sp_OADestroy, sp_OAMethod to instantiate the COM object. Unzip the Zip file into a folder and then register the Script.DLL using regsrv32.exe.
  • Here is an example: regsvr32 "E:\code\Script.dll"
  • To unregister the DLL: regsvr32 "E:\code\Script.dll" /u

• http://www.dbsolo.com/create_script.html - Script generator allows you to produce CREATE TABLE statements corresponding to your existing tables, indexes and constraints.
  • $49 after 30 days.

Bobsgear - Get A Free Enterrpise Wiki Space!
Review: The Bobsgear Project was started to develop a variety of Confluence plugins. This installation of the Confluence Enterprise wiki includes flexible attachments, many Confluence plugins, personal blogs, interesting articles, and more. Bobsgear already has spaces related to politics, art and photography wiki, technical issues wiki, ediscovery wiki, health, Christian theology and Sabbath School wiki, the bible, book reviews, and quotations. Bobsgear allows free signup, and invites anyone to create a free hosted Confluence wiki space.

NEW USERS CLICK HERE! for a quick introduction to Wiki.

Elapsed:0