Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag RESEED Rss

   Items 1 to 2 of 2   
 

Expanding identity to negative values

Identity integer can be max 2mld, if the table has many rows I can expand the identity.  Read more...
By Federico Iori 2012/02/10 | Source: SQLServerCentral.com | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 564 reads

RESEED in SQL 2000 and SQL 2005/2008

This article looks at the difference in behavior of RESEED in SQL Server 2000 and SQL Server 2005/2008  Read more...
By Raghuram (AJ) 2008/05/20 | Source: SQLServerCentral.com | Category: reseed
Rating: |  Discuss |   Briefcase | 3,821 reads
   Items 1 to 2 of 2   
 
Tags
identity property (2)    
checkident (1)    
expanding (1)    
int (1)    
max (1)