New article on CodeProject.com: SMO Tutorial 1 of n - (Programming data storage objects)

Today I have posted new article on CodeProject.com. This is a first article from series of articles about Server Management Objects (SMO) and programming tasks using SMO.

First part of this series is about creating and managing databases storage objects. Here is a table of contents:

• Introduction
• Background
• Connecting to SQL Server
  
• Working with databses
  
  • Enumerating databases, filegroups and files
  • Enumerating database properties
  • Creating databases
  • Database backup
  • Database restore
• Tables
  
  • Enumerating tables and columns
  • Creating and removing tables
  • Checking table integrity
• Views
  
  • Enumerating Views
  • Creating and removing views
• Stored procedures
  
  • Enumerating stored procedures
  • Creating stored procedure
• Triggers
  
  • Creating DML Trigger
  • Creating DDL Trigger
• Schemas
  
  • Enumerating schemas
  • Creating schemas