Error handling in sql server 2005, and later versions - Part 56

Script to Get Error Numbers and Messages from SQL Server Error Log

How to implement error handling in SQL Server

Alter Table Modify Column ONLINE Issues in SQL Server

Best way to change the datatype of a column in a Table with 20 million - Ask TOM

SQL Server Data Type Conversion Methods and performance comparison

SQL ALTER TABLE to Add, Delete and Change Columns in a Table

CREATE OR ALTER statement in SQL Server

An overview of the SQL table variable