Source Codes

• Sql server FAQ

  It covers topics like Database Transactions, Database Concurrency, moving database diagrams, clear the transaction log etc.

ARTICLES

• Automating SQLServer database from VB using SQLDMO - Part-I

  The article looks at automating Microsoft SQL server from visual basic using SQL Distributed Management Objects (SQLDMO object library). In this part, I'll explain about connecting to Sqlserver, getting a list of all the available databases, tables and fields.

• Automating SQLServer database from VB using SQLDMO - Part-II

  In this Part, I'll look at creating a databases, adding tables to the database,and adding columns to tables using SQLDMO.

• Automating SQLServer database from VB using SQLDMO - Part-III

  In this part, I'll look at altering an existing Table by adding a new column and populating the existing rows in the table with a default value. I also look at adding a Computed Column to the table using SQLDMO.

• Global variables in sql server 2000

  A quick reference point for Global variables in sql server 2000