> I had several occurrences of a problem when using the "Identity"
sql server sp3 or sp4 should have fixed most of these. also
you might have made use of an sp that does a DBCC against
tables w/identity columns at startup (most of the problems
happen when sql server was shut down badly).
> Does anyone have any good reason for using MAX(ID) over "Identity" on SQL
&.0?
i am a big fan of @@IDENTITY or even using TRIGGERs
to return identity values, so none whatsoever.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
