title: Set Maximum Value for an Identity Column in SQL SERVER 2005
body: <p>I am developing an Windows pplication(using Visual Studio 2008,Sql server 2005). I have to maintain userlog information. I am having an identity column. It is working fine. But now the value of identity column is 172. Again when I try to log on I am getting the error as:</p>
  
  <p>Violation of Primarykey pk_userLogId cannot insert duplicate values in an object'dbo.UserLog'.
  The statement has been terminated.</p>
  
  <p>When I close the error dialog box I am able to still use the application but the userlog is not being maintained.</p>
  
  <p>What should I do to avoid getting this error message?</p>
  
  <p>Is there any way I could set the maximum value for an identity column?</p>
  
  <p>please help me out!
  Thanks in advance!</p>