What datatype should be used for the Id primary key columns using a hilo generator and sql server?

Question

If I am using a hilo generator with nhibernate, what should the datatype for my id column be? int or bigint?

Answer 1

What are the data requirements? If you need more than 2 billion rows, including deletes/rollbacks then go bigint EDIT: I suppose you could start the identity at -2 billion and get double your pleasure