SQL Server identity

I am developing a asp.net application and i am using SQL Server 2008. I too开发者_Python百科k a IDENTITY column as Record_ID for detail table where i will have trillions of records per year. So just want to ask whats the largest number record id (identity) column can hold and in ASP.NET which data type i should use to handle record id as i am using this id as a reference to update the table data. I don't want to end up being trapped some day.

Guide me accordingly please.

An IDENTITY can be any of the integer types, so the size is determined by the actual column type (INT, BIGINT, etc) and not the fact alone that it's an identity.

Max/min values are here: http://msdn.microsoft.com/en-us/library/ms187745.aspx

In all cases these are signed values, so (for example) INT is Int32 (or int), and BIGINT is Int64.