I have a Microsoft SQl server 2005 database with a table whose primary key has the identity specification is set to yes to auto increment.

Recently the primary key skipped two numbers(which I understand is normal as they are not necessarily sequential).

However I would like to find out, if possible, why they skipped and when, i.e. if a stored procedure rollback occured and the primary key sequence didn't rollback or they were deleted somehow.

My question is, does Microsoft SQL server management studio have a **designated** area that stored records such as this, i.e. transaction logs etc for me to have a look at to try and determine why this skip happened.