Hi all,
I'm recommending the use of identity columns for primary keys for a database I'm working with as opposed to a key generation proc and table scheme. I've never had a problem with identity columns but want to toss this question out to the group. Does anyone know of any downsides to identity columns?

Also, we are going to have some free form comment fields in the database and I was thinking about using text fields. Any opinions? Thanks.

Gary