MS SQL Server Articles

     Triggers
     Developing Your Own SQL Server Based Data Access Helper using COM+ and VB.NET
     Completing Your Own SQL Server Based Data Access Helper using COM+ and VB.NET
     A Wrapper Class for the SQL Server Based Data Access Helper
     .NET CLR Programming with SQL Server 2005 Made Simple
     Copying a Table from Oracle 10G XE to SQL 2000 Server using DTS
     Scripts and Transactions in Transact-SQL
     More About Transactions and Composite Transact-SQL Constructs
     Trigger Specifics
     Trigger Management
     Transferring a Database Using the SSIS Designer
     Using Oracle Developer Tools with Visual Studio
     Designing and Modifying Triggers
     Using Triggers
     Notification Services
     A Secure Way of Building Connection Strings
     Building a Multi-table Report with SQL 2005 Reporting Services
     Blocking Bad Data
     Working wth Variables in Database Interactions with Transact-SQL
     How to Use Variables, IF and CASE in Database Interactions with TransactSQL
     Using @@ROWCOUNT and TABLE Variables for Database Interactions with Transact-SQL
     Delving Deeper into Notification Services
     Creating Important Aspects of Notification Services
     Using Masks to Block Bad Data
     Field Validation Rules for Blocking Bad Data
     Lookups and Blocking Bad Data

Page 2 of 2: 1, 2