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

Simple way to find errors in SQL Server error log

Common SQL syntax errors and how to resolve them

Monitor SQL Server IDENTITY Column Values to Prevent Arithmetic Overflow Errors

Add or drop identity property for an existing SQL Server column

Identity column in SQL Server - Part 7

SQL Server ALTER TABLE ADD Column overview

SQL ALTER TABLE : ADD, DROP, MODIFY, RENAME - Shiksha Online

An overview of the SQL table variable