Find the Missing Identity Numbers in SQL Server 2005/2008

We as Database Developers often come across tables that have identity columns. Many a times, there are missing rows in that table, which have probably been deleted during a database operation. Have you wondered how to find the missing rows? Read on..