Arthur Fuller
artful at rogers.com
Wed Jul 6 17:29:40 CDT 2005
In theory, yes. In practice, if the scope of an Identity column is insufficient, use a GUID instead. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: July 5, 2005 6:03 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] limit to records? Anybody know what the limit would be using an identity column -- eventually, the identity column's going to hit a ceiling, right? Susan H. Microsoft says it's only limited by the amount of available storage, but somewhere else they say that a file can't be larger than 32 tb. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com